October 31, 2011 at 4:16 pm
Hi,
we have Log shipiing Configured on server with readonly stand by DB. Now i want to move to the Datamirriong instead of logshipping..
Database is huge(around 600 GB), so i don't want to do the Datamirriong from scratch.
Is there a way to remove the logshipping but put that secondary DB on In-recovery Mode, so i can configure Data Mirroring fast because DB is alreday intialized on secodary server...
Thanks for your help in advance.. 🙂
October 31, 2011 at 4:25 pm
Essentially you would do the same steps as if failing over from the primary to the secondary - but you leave the primary in place.
So, break logshipping and bring the secondary online.
http://msdn.microsoft.com/en-us/library/ms178117.aspx
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
October 31, 2011 at 4:29 pm
If they are not already in that state switch the log shipping restores to norecovery and restore up to the very latest log so the database is in in recovery mode.
Remove logshipping
Set up database mirroring.
take one more log backup and restore it to the secondary with norecovery, mirroring should be good to go.
---------------------------------------------------------------------
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply