Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

database snapshots -restoring status

0 views
Skip to first unread message

noorhayatishamsuddin

unread,
Nov 17, 2009, 10:11:26 PM11/17/09
to
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/aspnet/d125a91e-0c2d-4ef4-a505-4250336dab5a/webservice-binaryformatte.aspx

Uri Dimant

unread,
Nov 18, 2009, 5:31:06 AM11/18/09
to
>Can I drop and recreate the database snaphots?
Yes

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

sp_who 'active'

amd looking at dbname column

<noorhayati shamsuddin> wrote in message
news:200911172...@yellowpages.com.my...

0 new messages