SQL database log file is full for database called VCUPDATE

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
bermudahsAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

micropc1Commented:
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
bermudahsAuthor Commented:
We use Symantec backup exec and I can confirm that no jobs are running.
0
micropc1Commented:
I'm not sure about Backup Exec, but have you looked at the Activity Monitor in SQL Server Management Studio?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

bermudahsAuthor Commented:
I looked under Job Activity Monitor and everything is idle.
0
Scott PletcherSenior DBACommented:
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
bermudahsAuthor Commented:
I will try your suggestion.  Any idea what the VCUPDATE database is?
0
Scott PletcherSenior DBACommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.