October 19, 2009 at 1:57 pm
Hi,
We are planning to perform a DR test for our applications & databases. We have the below environment
Primary:
Apllication Server---Server A
SQL Server 2005--Server B
Secondary:
DR Apllication Server---DRServer A
DR SQL Server 2005-- DRServer B
We are using Log shipping as our DR solution and want to test the DR.
Steps:
1.Disable all the log shipping jobs on Primary & Secondary.
1Connect the DR application and test some transactions & make sure DR test worked.
3.Now, Is there any process to simply go back to the state before the start of DR test(purpose: all log shiping configuration should be vailable again and Log shipping should work as usual after the DR test)
Because, in general, after bringing the secondary online do we need to reconfigure the entire log shipping from the Primary, by first disabling log shipping and then taking full backup and restore in secondary and configure log shipping?
How exactly it works?
After DR test, If we must need to configure Log shipping again by taking full backup of databases on Primary & restore on Secondary with NORECOVERY & configure log shipping, what happens to the Disabled log shipping jobs(which are disabled before the start of DR test)
please advice..
thanks
October 19, 2009 at 2:52 pm
Given that this is a OLTP test.
In step 1 after disabling jobs
Dont forget to restore the last tran log from primary to secondary.
Failing Over to a Log Shipping Secondary
http://msdn.microsoft.com/en-us/library/ms191233%28SQL.90%29.aspx
Changing Roles Between Primary and Secondary Servers
http://msdn.microsoft.com/en-us/library/ms178117%28SQL.90%29.aspx
October 22, 2009 at 3:43 pm
After DR test, If we must need to configure Log shipping again by taking full backup of databases on Primary & restore on Secondary with NORECOVERY & configure log shipping, what happens to the Disabled log shipping jobs(which are disabled before the start of DR test)
Please advice on the above question
many thanks
October 23, 2009 at 3:58 pm
Any more inputs on this plz...
October 26, 2009 at 12:44 am
Hi,
I just want to know that is any there way to go back to the same state for Primary and Secondary SQL Instances (i.e state before starting DRT Test) after bringing Secondary online using Log shipping??
Is the below scenario works?
Before Start the DR Test (Failover/Role switch), On secondary
1.stop the SQL Service and copy the .mdf files & .ldf files and save them.
2.bring the secondary databases online and make the Secondary instance as primary and Primary instance as secondary & run some transation and verify the DR test.
3.Once DR test completes, I want to restore the the copied .mdf & .ldf files (by using attach database method). But how can attach the database with NORECOVERY so that I can configure Log shipping from Primary to Secondary again?
Is that Possible OR do I must need to send the backups from Primary instance to Secondary and Restore with NORECOVERY option and then start Log shipping configuration?
please advcie
October 29, 2009 at 1:19 pm
Mani-584606 (10/26/2009)
Hi,I just want to know that is any there way to go back to the same state for Primary and Secondary SQL Instances (i.e state before starting DRT Test) after bringing Secondary online using Log shipping??
Is the below scenario works?
Before Start the DR Test (Failover/Role switch), On secondary
1.stop the SQL Service and copy the .mdf files & .ldf files and save them.
2.bring the secondary databases online and make the Secondary instance as primary and Primary instance as secondary & run some transation and verify the DR test.
3.Once DR test completes, I want to restore the the copied .mdf & .ldf files (by using attach database method). But how can attach the database with NORECOVERY so that I can configure Log shipping from Primary to Secondary again?
Is that Possible OR do I must need to send the backups from Primary instance to Secondary and Restore with NORECOVERY option and then start Log shipping configuration?
please advcie
Mani
Read this carefully
Changing Roles Between Primary and Secondary Servers
http://msdn.microsoft.com/en-us/library/ms178117%28SQL.90%29.aspx
October 30, 2009 at 12:04 pm
thanks Alex,
I read the failover & role switch in above msdn links. My only question is: Is there way to go back to the prior state of Primary and Secondary SQL Instances (i.e state before starting DRT Test) after bringing the secondary online and role switch using Log shipping??
Or we must need disable Log shipping(all log shipping jobs will be removed) and then again take the full backup of primary databases and restore in Secondary with NORECOVERY and configure log shipping from the scratch after the completion of DR test ?
many thanks
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply