Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » DBCC CHECKDB errors
Add to briefcase
13 posts, Page 1 of 2
12»»

DBCC CHECKDB errors Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
robert.gerald.taylor
Posted Tuesday, September 25, 2012 6:23 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: 2 days ago @ 6:44 AM
Points: 759, Visits: 802
I tried running: DBCC CHECKDB ('DatabaseName') WITH NO_INFOMSGS;

And got the errors:

Msg 1823, Level 16, State 2, Line 1
A database snapshot cannot be created because it failed to start.
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 9001, Level 21, State 1, Line 1
The log for database 'DatabaseName' is not available. Check the event log for related error messages. Resolve any errors and restart the database.
Msg 9001, Level 21, State 1, Line 1
The log for database 'DatabaseName' is not available. Check the event log for related error messages. Resolve any errors and restart the database.

The good news is that this database is not in active use anymore. But does this indicate I may have an issue in my storage system? I'd like to nail this down before a database I care about goes bad. (Yes, we have full backup and transaction log backups)

What's the next steps?

Thanks,
Rob
Post #1363972
GilaMonster
Posted Tuesday, September 25, 2012 6:30 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 4:08 PM
Points: 38,099, Visits: 30,392
Are there any related messages in the event log?

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass
Post #1363984
robert.gerald.taylor
Posted Tuesday, September 25, 2012 6:36 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: 2 days ago @ 6:44 AM
Points: 759, Visits: 802
GilaMonster (9/25/2012)
Are there any related messages in the event log?


Looking in Event Viewer on the server under Administrative Events, I see "The log for database 'DatabaseName' is not available. Check the event log for related error messages. Resolve any errors and restart the database" listed a number of times.

I don't see any other errors (like in the Windows Logs\System) that apply.
Post #1363995
GilaMonster
Posted Tuesday, September 25, 2012 7:13 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 4:08 PM
Points: 38,099, Visits: 30,392
Any messages about drives being unavailable?
Anything useful in the SQL error log?

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass
Post #1364022
robert.gerald.taylor
Posted Tuesday, September 25, 2012 7:31 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: 2 days ago @ 6:44 AM
Points: 759, Visits: 802
The SQL logs just have Error. 9001 Severity: 21. State: 1. - which I think is related to the bad log. And The log for database 'DatabaseName' is not available ... repeated over and over.

There is a log that says SQL Server has encountered 111 occurrences(s) of I/O requests taking longer than 15 seconds to complete on d:\Data\tempdb\mdf.

But that's it -- nothing else.

DBCC CHECKDB shows fine for other databases on that server.
Post #1364034
GilaMonster
Posted Tuesday, September 25, 2012 10:21 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 4:08 PM
Points: 38,099, Visits: 30,392
Nothing drive-related in the Windows event logs (application or system)

Does that DB's log share a drive with any other?
Are you running enterprise edition?

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass
Post #1364165
robert.gerald.taylor
Posted Tuesday, September 25, 2012 11:50 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: 2 days ago @ 6:44 AM
Points: 759, Visits: 802
GilaMonster (9/25/2012)
Nothing drive-related in the Windows event logs (application or system)

Does that DB's log share a drive with any other?
Are you running enterprise edition?

I just double checked the application and system Windows logs and there's nothing drive related there.

All of the .mdf and .ldf files for that server are on the same D:\ drive. There are aprox 20 other databases on that server.

No, SQL Server 2008 R2 Standard edition on that server.
Post #1364209
GilaMonster
Posted Tuesday, September 25, 2012 1:02 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 4:08 PM
Points: 38,099, Visits: 30,392
Odd. I've seen this before and couldn't figure it out then either.

Does this problem persist across restarts of SQL?

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass
Post #1364244
Nils Gustav Stråbø
Posted Tuesday, September 25, 2012 1:33 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 12:30 AM
Points: 1,788, Visits: 3,330
Any chance that you're running it on VMWare? I've seen DBCC CHECKDB errors (can't remember the exact message) and "I/O requests taking longer that 15 seconds" on one of our development servers.
Post #1364260
robert.gerald.taylor
Posted Tuesday, September 25, 2012 1:54 PM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: 2 days ago @ 6:44 AM
Points: 759, Visits: 802
Nils,
No, it is not on a virtual server.

Gail,
This is a production server; the scheduled reboot is this upcoming Sunday. Since this db isn't actively used, I think the plan is to see what happens after restarting SQL Server.

Thanks,
Rob
Post #1364274
« Prev Topic | Next Topic »

Add to briefcase
13 posts, Page 1 of 2
12»»

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.