question

MHD avatar image
MHD asked

SQL Server 2005 Database Mirroring

HI,

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.

sql-server-2005database-mirroring
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Blackhawk-17 avatar image Blackhawk-17 commented ·
Which way do you want to synchronize?
0 Likes 0 ·
Lynn Pettis avatar image
Lynn Pettis answered

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.

1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Matt Whitfield avatar image Matt Whitfield ♦♦ commented ·
Not that it's related, but good to see you here Lynn!
0 Likes 0 ·
mcoombes avatar image
mcoombes answered

MHD,

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

Mikey

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.