Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Restart mirroring for a log shipping environment after DR test Expand / Collapse
Author
Message
Posted Thursday, February 6, 2014 9:51 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, March 20, 2014 5:48 AM
Points: 1, Visits: 56
Hi all:

I have a 3 server setup at this time.
Goal is to do a DR test and bring the changes on secondary to primary.

I think my step 11 is wrong.

server 1 - Primary (mirroring and log shipping)
server 2 - mirror (primary)
server 3 - secondary (log shipping)

Can I retain mirroring between server 1 and 2 when I do the role switch?

Here is what I planned -

1. clean pre-test copy only backup
2. set partner off from primary
3. do a manual LS Backup on server1 and disable job, LS Copy and LS Restore on server 3and disable job
4. backup server 1 txn log with no recovery
5. copy and restore this tail txn log to server 3 with recovery
6. setup dr from server 3 (new primary) to server 1(new secondary)
7. Data tests on DR
8. do a manual LS Backup on server3 and disable job, LS Copy and LS Restore on server 1 and disable job
9. backup server 3 txn log with no recovery
10. copy and restore this tail txn log to server 1 with recovery
11. enable server 1 as partner
12. enable LS jobs on server 1 and 3.

Post #1538740
Posted Friday, February 7, 2014 3:05 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 3:49 AM
Points: 6,185, Visits: 13,332
consult this article first


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1539061
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse