x

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.

more ▼

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

MHD gravatar image

MHD
1 1 1 1

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

Lynn Pettis gravatar image

Lynn Pettis
275 3

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

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

more ▼

answered Feb 09, 2010 at 10:04 PM

mcoombes gravatar image

mcoombes
33 2 2 3

(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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x1951
x57

asked: Feb 09, 2010 at 04:38 AM

Seen: 1660 times

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