Comprehensive data protection for all workloads
Post Reply
pclhs
Lurker
Posts: 1
Liked: never
Joined: Jun 13, 2011 9:19 pm
Contact:

Restoring a mirrored sql db

Post by pclhs »

We use veeam to back our MS SQL db's and last night one had serious corruption.

We're skeptical to restore the entire vm because they were synced to a point and dont know if going back will just resync or cause more damage.

Any advice?
Vitaliy S.
VP, Product Management
Posts: 27377
Liked: 2800 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Restoring a mirrored sql db

Post by Vitaliy S. »

Hello Matt,

I'm not a DBA, but I believe a way to go would to disable mirroring, restore your backups to a healthy state and then use standard procedures for restoring a mirrored database.

I've searched for the links that might help, please have a look at this one:
http://blogs.technet.com/b/askcore/arch ... abase.aspx

Thanks.
Post Reply

Who is online

Users browsing this forum: Bing [Bot], Majestic-12 [Bot], Semrush [Bot] and 254 guests