SQL Server 2005 Database Mirroring


I have primary server A, secondary server B is mirror of A on SQL Server 2005 Enterprise Edition. I want to test on mirror server after breaking mirror, later want to synchronize without backup restore. Can anybody help for this scenario.

more ▼

asked Feb 09, 2010 at 04:38 AM in Default

avatar image

1 1 1 2

Which way do you want to synchronize?

Feb 09, 2010 at 12:52 PM Blackhawk-17
(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

If you break the mirror and then run RESTORE WITH RECOVERY to use the database for testing, the only way you will be able to restore the mirror is a restore of the database from a full backup and t-logs from the principal server.

more ▼

answered Feb 23, 2010 at 06:10 PM

avatar image

Lynn Pettis
275 2 5

Not that it's related, but good to see you here Lynn!

Feb 23, 2010 at 06:14 PM Matt Whitfield ♦♦
(comments are locked)
10|1200 characters needed characters left


Is there a particular reason you don't want to do a restore on the test box by using "Backup Restore"?

I would have thought that would be the best way to do it to prevent any contamination of your 'production' database form your 'test' database. It is a slower process, but not by that much and I have always thought it was a 'safer' option


more ▼

answered Feb 09, 2010 at 10:04 PM

avatar image

33 3 2 5

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Feb 09, 2010 at 04:38 AM

Seen: 1820 times

Last Updated: Feb 09, 2010 at 06:31 AM

Copyright 2018 Redgate Software. Privacy Policy