August 24, 2015 at 2:10 pm
One of my DBCC checktable failed with below message. When i manually executed it ran fine, no error messages. I couldn't find anything directly related to this message.
Date and time: 2015-08-22 05:12:23
Command: USE [MyDb]; DBCC CHECKTABLE ('[dbo].[MyTable]') WITH NO_INFOMSGS, ALL_ERRORMSGS, DATA_PURITY
Msg 5269, Level 16, State 4, Server MyServer, Line 1
Check terminated. The transient database snapshot for database 'MyDb' (database ID 9) has been marked suspect due to an IO operation failure. Refer to the SQL Server error log for details.
Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : Unspecified error.
August 25, 2015 at 4:53 am
Part of the DBCC process creates a snapshot of the database. That snapshot was marked corrupted due to an I/O issue (undetermined from here). So your main database is fine.
However, it suggests that you might have issues on your disk or with your I/O sub-system... Maybe. Check the error logs in the OS to see if there's additional information there. If you're on a SAN, check there. Otherwise, it might just be a one-off glitch. They happen, rarely.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply