|
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.
(comments are locked)
|
|
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. Not that it's related, but good to see you here Lynn!
Feb 23 '10 at 06:14 PM
Matt Whitfield ♦♦
(comments are locked)
|
|
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
(comments are locked)
|
Which way do you want to synchronize?