?
Solved

Backupexec/dbcc fails - database snapshot cannot be created

Posted on 2012-08-27
6
Medium Priority
?
2,201 Views
Last Modified: 2012-10-04
Hi,

I recently had a fail error on a backup stating

Backup- \\Servername\Microsoft Information Store\First Storage Group An unknown or unexpected database error occurred while attempting a DBCC.
A database snapshot cannot be created because it failed to start.

Consistency checking DBNAME
An unknown or unexpected database error occurred while attempting a DBCC.
A database snapshot cannot be created because it failed to start.

I then started SQL2005 and ran

DBCC CHECKDB(DBNAME)
GO

And received the following results:

Msg 1823, Level 16, State 2, Line 1
A database snapshot cannot be created because it failed to start.
Msg 5149, Level 16, State 1, Line 1
MODIFY FILE encountered operating system error 112(There is not enough space on the disk.) while attempting to expand the physical file.
Msg 7928, Level 16, State 1, Line 1
The database snapshot for online checks could not be created. Either the reason is given in a previous error or one of the underlying volumes does not support sparse files or alternate streams. Attempting to get exclusive access to run checks offline.
Msg 5030, Level 16, State 12, Line 1
The database could not be exclusively locked to perform the operation.
Msg 7926, Level 16, State 1, Line 1
Check statement aborted. The database could not be checked as a database snapshot could not be created and the database or table could not be locked. See Books Online for details of when this behavior is expected and what workarounds exist. Also see previous errors for more details.


The only thing that I know was changed in recent history was the admin user password was changed and we had to change the backupexec credentials in the backupexec services. All of our other databases seem to backing up successfully and its only this specific database.

Thanks in advance
0
Comment
Question by:sem212x
  • 4
  • 2
6 Comments
 

Author Comment

by:sem212x
ID: 38337076
I checked event viewer and I have the following Error in application

D:\SQLData\DBNAME.MDF:MSSQL_DBCC12: Operating system error 112(There is not enough space on the disk.) encountered.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Does this just mean I do not have enough space on my drive? The .mdf is only only 176,640 kb large and the .LDF is 737,472 kb large

I have 89gb of free space..
0
 
LVL 10

Expert Comment

by:chubby_informer
ID: 38337102
reinstall agent
0
 

Author Comment

by:sem212x
ID: 38337157
even though all other databases are passing consistency checks?
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 10

Expert Comment

by:chubby_informer
ID: 38436817
yes.

Please advise on a status on this issue
0
 

Accepted Solution

by:
sem212x earned 0 total points
ID: 38447873
we backed up the database and restored it to a new db, the new db passed the dbcc and all is well.
0
 

Author Closing Comment

by:sem212x
ID: 38462384
It just worked.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Windows Server 2003 introduced persistent Volume Shadow Copies and made 2003 a must-do upgrade.  Since then, it's been a must-implement feature for all servers doing any kind of file sharing.
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
This tutorial will walk an individual through the process of configuring basic necessities in order to use the 2010 version of Data Protection Manager. These include storage, agents, and protection jobs. Launch Data Protection Manager from the deskt…

578 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