Hi,

I had restored a production database backup to a TRAINING database using symantec.I accidently asked symantec to restore model,msdb and database snaphots to an existing TRAINING database. Symantec reported that there is database inconsistancies and when I check the instance, the database snapshots are in restoring status. What should I do to resolve the problem? Can I drop and recreate the database snaphots? How to know whether is there any connections to that database snapshots?



EggHeadCafe - Software Developer Portal of Choice
WebService BinaryFormatter / Image Serialization
http://www.eggheadcafe.com/tutorials...yformatte.aspx

How to know whether is there any connections to that database snapshots?

sp_who 'active'

amd looking at dbname column

<noorhayati shamsuddin> wrote