Solved

SQL database log file is full for database called VCUPDATE

Posted on 2012-03-21
7
457 Views
Last Modified: 2012-03-30
I’ve inherited a SQL 2005 database called VCUPDATE that currently has a full log.  I suspect this database is for VMware Virtual Center but I’m not 100% sure?

The recovery model is set to “Simple” and the last database log backup is “None”.  

When I try to do either a backup or shrink log file I get an error.  Please see attached screenshot for error.
3-21-2012-4-26-13-PM.png
0
Comment
Question by:bermudahs
  • 3
  • 2
  • 2
7 Comments
 
LVL 7

Expert Comment

by:micropc1
Comment Utility
You will see that error if you attempt to issue an ALTER DATABASE ADD/REMOVE FILE command or truncate the database while a backup is already in progress. Check your active jobs to make sure a backup job isn't already running.

http://msdn.microsoft.com/en-us/library/aa238194(v=sql.80).aspx
0
 

Author Comment

by:bermudahs
Comment Utility
We use Symantec backup exec and I can confirm that no jobs are running.
0
 
LVL 7

Expert Comment

by:micropc1
Comment Utility
I'm not sure about Backup Exec, but have you looked at the Activity Monitor in SQL Server Management Studio?
0
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

 

Author Comment

by:bermudahs
Comment Utility
I looked under Job Activity Monitor and everything is idle.
0
 
LVL 69

Expert Comment

by:ScottPletcher
Comment Utility
Something's running that requires serialization, most likely another backup or shrink.

You can't backup the log if the db is in simple mode.

First, see if this gives a reason the log can't be shrunk:

SELECT name, log_reuse_wait_desc
FROM master.sys.databases
WHERE name = N'VCUPDATE'


You can do this if you're sure you can kill all other activity on the db:
-- BEFORE RUNNING: Be sure to VERIFY logical log file name and change if needed


USE VCUPDATE

ALTER DATABASE VCUPDATE
SET SINGLE_USER WITH ROLLBACK IMMEDIATE

DBCC SHRINKFILE (VCUPDATE_LOG, 10) -- replace "VCUPDATE_LOG" if needed

ALTER DATABASE VCUPDATE
SET MULTI_USER
0
 

Author Comment

by:bermudahs
Comment Utility
I will try your suggestion.  Any idea what the VCUPDATE database is?
0
 
LVL 69

Accepted Solution

by:
ScottPletcher earned 500 total points
Comment Utility
What the logical file name is?

No, but you can find it easily enough.

USE VCUPDATE

EXEC sp_helpfile


The first column contains the logical names.  Copy the one for the log file.

You can also use the file#.  Log files are usually file #2 but that's not guaranteed.

DBCC SHRINKFILE (2, 10) -- shrink file #2 (verify #2 is log file before using!!)
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Backing up a vmware workstation 3 32
CHAP for iscsi 4 32
Vmware 5.5 3 21
svMotion between two different datastore limitation ? 3 34
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In this step by step tutorial with screenshots, we will show you HOW TO: Enable SSH Remote Access on a VMware vSphere Hypervisor 6.5 (ESXi 6.5). This is important if you need to enable SSH remote access for additional troubleshooting of the ESXi hos…
Teach the user how to edit .vmx files to add advanced configuration options Open vSphere Web Client: Edit Settings for a VM: Choose VM Options -> Advanced: Add Configuration Parameters:
This Micro Tutorial steps you through the configuration steps to configure your ESXi host Management Network settings and test the management network, ensure the host is recognized by the DNS Server, configure a new password, and the troubleshooting…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now