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.
Answer by Lynn Pettis ·
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.
Answer by mcoombes ·
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