?
Solved

SQL database log file is full for database called VCUPDATE

Posted on 2012-03-21
7
Medium Priority
?
472 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
7 Comments
 
LVL 7

Expert Comment

by:micropc1
ID: 37749439
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
ID: 37749449
We use Symantec backup exec and I can confirm that no jobs are running.
0
 
LVL 7

Expert Comment

by:micropc1
ID: 37749499
I'm not sure about Backup Exec, but have you looked at the Activity Monitor in SQL Server Management Studio?
0
Flexible connectivity for any environment

The KE6900 series can extend and deploy computers with high definition displays across multiple stations in a variety of applications that suit any environment. Expand computer use to stations across multiple rooms with dynamic access.

 

Author Comment

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

Expert Comment

by:Scott Pletcher
ID: 37754703
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
ID: 37754755
I will try your suggestion.  Any idea what the VCUPDATE database is?
0
 
LVL 69

Accepted Solution

by:
Scott Pletcher earned 1500 total points
ID: 37754771
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

Enroll in August's Course of the Month

August's CompTIA IT Fundamentals course includes 19 hours of basic computer principle modules and prepares you for the certification exam. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article, I will show you HOW TO: Create your first Windows Virtual Machine on a VMware vSphere Hypervisor 6.5 (ESXi 6.5) Host Server, the Windows OS we will install is Windows Server 2016.
Ransomware is a malware that is again in the list of security  concerns. Not only for companies, but also for Government security and  even at personal use. IT departments should be aware and have the right  knowledge to how to fight it.
Teach the user how to install log collectors and how to configure ESXi 5.5 for remote logging Open console session and mount vCenter Server installer: Install vSphere Core Dump Collector: Install vSphere Syslog Collector: Open vSphere Client: Config…
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…

764 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