hello

Our last CheckDB failed on the 02/09. We were having problems with our SAN then and that got sorted out. The databases that it failed still has the snapshot showing in SQL Management Studio, screenshot exemple below (server name blanked out)

I reran CheckDB on the 04/09 on all the databases and the same databases that failed on the 02/09 failed again. I noticed in the log file, it tried to use the same snapshot file created on  02/09 to run CheckBD

I ran CheckDB manually on the databases that failed "DBCC CheckDB (WSS_Content_ce) with all_errormsgs" and did not get any errors back. 

How do I remove the snapshot databases? We had a problem on 02/09 so the snapshot copy obvisouly has problems. I'd like to remove these snapshots and rerun a CheckDB on all the databases to ensure all is ok.

Thank you all in advance

• Edited by fiogeekgurl 7 hours 7 minutes ago

BOL:

Drop a Database Snapshot (Transact-SQL

If you checkDb is part of a job, check the job carefully to understand what is happening.

Read the below post to understand about internal snapshot..

If you checkDb is part of a job, check the job carefully to understand what is happening.

Read the below post to understand about internal snapshot..

https://msdn.microsoft.com/en-us/library/ms176064.aspx?f=255&MSPPError=-2147217396

hello

Our last CheckDB failed on the 02/09. We were having problems with our SAN then and that got sorted out. The databases that it failed still has the snapshot showing in SQL Management Studio, screenshot exemple below (server name blanked out)

I reran CheckDB on the 04/09 on all the databases and the same databases that failed on the 02/09 failed again. I noticed in the log file, it tried to use the same snapshot file created on  02/09 to run CheckBD

I ran CheckDB manually on the databases that failed "DBCC CheckDB (WSS_Content_ce) with all_errormsgs" and did not get any errors back. 

How do I remove the snapshot databases? We had a problem on 02/09 so the snapshot copy obvisouly has problems. I'd like to remove these snapshots and rerun a CheckDB on all the databases to ensure all is ok.

Thank you all in advance

What you have shown is not a snapshot are you sure about this ? Checkdb does not creates snapshot DB likes one you have shown. The snapshot created by checkdb is internal one and you cannot see it untill 2012. You can see it from 2014 onwards.

IIRC this is database created by sharepoint

hello

Our last CheckDB failed on the 02/09. We were having problems with our SAN then and that got sorted out. The databases that it failed still has the snapshot showing in SQL Management Studio, screenshot exemple below (server name blanked out)

I reran CheckDB on the 04/09 on all the databases and the same databases that failed on the 02/09 failed again. I noticed in the log file, it tried to use the same snapshot file created on  02/09 to run CheckBD

I ran CheckDB manually on the databases that failed "DBCC CheckDB (WSS_Content_ce) with all_errormsgs" and did not get any errors back. 

How do I remove the snapshot databases? We had a problem on 02/09 so the snapshot copy obvisouly has problems. I'd like to remove these snapshots and rerun a CheckDB on all the databases to ensure all is ok.

Thank you all in advance

What you have shown is not a snapshot are you sure about this ? Checkdb does not creates snapshot DB likes one you have shown. The snapshot created by checkdb is internal one and you cannot see it untill 2012. You can see it from 2014 onwards.

IIRC this is database created by shar