May 4, 2009 at 1:32 pm
Hi,
I have configured log shipping in sql server 2005 and the logs are shipping to the secondary database. I inserted some data in primary database and restored the last transaction log backup with recovery option and the secondary database is online and I verified the inserted data and is available in secondary database.
Now,how to failover\role switch?In real time scenario, we will bring the secondary database up only when primary is completly unavailble and the business is running on the secondary database and data is updated.Primary is back online. Now how to transfer these changes happened to data to primary from secondary?
May 5, 2009 at 7:21 am
If your primary is available during failover, then you would backup your TL with no recovery. Then you could apply TL backups from your secondary that you failed over. If primary not available, you need to manually set it back up again.
Check these:
http://msdn.microsoft.com/en-us/library/ms191233(SQL.90).aspx
http://msdn.microsoft.com/en-us/library/ms178117(SQL.90).aspx
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply