March 31, 2009 at 6:56 am
Hello dear frndz,
I m monitoring my SQL Server in error log i got this error message,
‘Database snapshot 'Database_name' has failed an IO operation and is marked suspect. It must be dropped and recreated.’
Source spid69
Message
Error: 3420, Severity: 21, State: 1.
I am not able to understand this issue, i search this db in object explorer its not showing, i run the 'sys.database' its showing status online, while i run the 'sp_helpdb dbname' it showing other db name. Can anybody please help me out.
Thanks in advance.
M.I.
________________________________________
M.I.
[font="Times New Roman"]
March 31, 2009 at 7:26 am
Have you run DBCC CHECKDB on the database?
The following article may be of use to you as it has specific reference to your error.
http://support.microsoft.com/kb/967164
Let me know how you get on.
March 31, 2009 at 8:34 am
If the database has a snapshot created against it, you would need to drop & recreate it.
March 31, 2009 at 8:52 am
I used DBCC CHECKDB command with the db name its working fine.
while i m runing the sp_helpdb dbname (for knowing the physical address of the particular db) in first query result its showing the that db name, but in second query result with log file its showing other db name.
And this db name also not showing on 'object explorer' in db list.
What it is exactly, i m not understand what happen with my db.
Please tell me the possible solution for this.
________________________________________
M.I.
[font="Times New Roman"]
March 31, 2009 at 9:01 am
I'm confused....
The secondary result set returned from sp_helpdb 'DBName' returns details of the data files and has no reference to any database objects.
The 'name' column of the secondary data set refers to the name (not the same as the filename necessarilly) assigned to the file.
The object you are looking for is not a database but rather a 'Database Snapshot'. I suggest you read up on the following Books Online article in order to develop an understanding of the concepts at work here.
http://msdn.microsoft.com/en-us/library/ms175158(SQL.90).aspx
Snapshots should reside within the 'Databases > Database Snapshots' folder of Object Explorer.
Cheers,
March 31, 2009 at 9:17 am
Something happened in your i/o system and it rendered the copy-on-write a failure in the snapshot. When SQL detects an issue, it tends to just whack the snapshot. It doesn't keep that information around to retry.
Are there other entries in the log?
Any windows log entries with IO issues? Is the snapshot on a different drive?
March 31, 2009 at 10:09 am
One more thing i checked now its not showing that db on the physical location of all the db's.
but while i m running dbcc checkdb its runing fine.
So it mean i want to restore the backup of this db or wht to do?
Please suggest me.
________________________________________
M.I.
[font="Times New Roman"]
May 17, 2012 at 12:31 am
we have same issue, it happens sometimes because the disk which snapshot files resides becomes full. there are case that we have plenty of space again it is marked suspect. we are searching for a solution.
Regards,
MShenel
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply