database snapshots -restoring status

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?

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

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

sp_who 'active'

amd looking at dbname column