SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


When you resume database mirroring


When you resume database mirroring

Author
Message
geuncho4
geuncho4
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
Points: 6 Visits: 5
In SQL Server 2008, if database mirroring breaks for some reason, and you want to resume mirroring with the principal again taking on the role of the principal after the mirroring temporarily served as principal, do you need to go back to square one? Meaning do you need to do full backup and t-log backup of the principal database and restore it on the mirror with no recovery? Or can you just run the below on the principal without without going back to square one:

Use Master;
GO
Alter Database MyDB Set Partner Resume;


I belive going back to square on would not be needed, and above command or simply click Resume in Database Properties > Mirroring Page.
Jeffrey Williams 3188
Jeffrey Williams 3188
SSCoach
SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)

Group: General Forum Members
Points: 18953 Visits: 10042
It depends on what has happened on the principal after mirroring has been stopped. If you have a continuous log chain, then all you need to do is apply the transaction log backups to the mirror and restart mirroring.

If the log chain is broken, you have to reinitialize with a new backup and restore.

If the mirror is brought online, again - you have to start from the beginning again.

Jeffrey Williams
Problems are opportunities brilliantly disguised as insurmountable obstacles.

How to post questions to get better answers faster
Managing Transaction Logs

geuncho4
geuncho4
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
Points: 6 Visits: 5
Hi Mr. Williams,
You said if the mirror is brought online, I have start over. Do you mean if the mirror becomes a new principal via manual or automatic fail-over, and when I'm ready to fail-back to the original primary, then I will have to remove the mirroring, and reinitialize with the backup of the mirror (since it was promoted as the primary) and restore to the original primary? Is that correct?
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search