November 29, 2010 at 8:40 am
I am here to ask expert opinion when I am in doubt about SQL server issues and thank you all for helping me out. But i did get some response which is offensive ,if you don't bother to advice then just stay away from my post...
DBCC error
Msg 1823, Level 16, State 1, Line 1
A database snapshot cannot be created because it failed to start.
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 823, Level 24, State 2, Line 1
The operating system returned error 38(error not found) to SQL Server during a read at offset 0x00000043230000 in file 'F:\SQLDataFiles\DWTest.mdf:MSSQL_DBCC14'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.
Msg 3313, Level 21, State 2, Line 1
During redoing of a logged operation in database 'DWTest',an error occurred at log record ID (304431:22586:20). Typically, the specific failure is previously logged as an error in the Windows Event Log service. Restore the database from a full backup, or repair the database.
Msg 0, Level 20, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.
Please help..
Thanks in advance
November 29, 2010 at 11:24 am
You have got some *serious* problems with that IO subsystem. Get some diagnostic done and problems fixed or get the databases onto other storage. Quickly.
Make sure no one is using that database and try to run CheckDB with the TABLOCK option. This requires that no one else is using the DB.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 29, 2010 at 11:29 am
Are you out of space?
http://www.sqlskills.com/blogs/paul/post/Database-snapshots-when-things-go-wrong.aspx
Use the DBCC CHECKDB......ESTIMATEONLY.
Just a thought.
November 30, 2010 at 9:19 am
Thanks a lot for your inputs
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply