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 Saturday, September 05, 2015 11:57 PM

There's already a thread on this subject where I replied a few days ago that SQL Server by itself doesn't create a copy of the database...

That's what we all mentioned even in your previous post that running checkdb will NOT create a physical database on your instance. Hope you got clarified

Hello everyone

Yes I'll close this thread. Actually I did not realise how the copied databases were created - I do now :-)

thank you everyone for your replies

regards