September 5, 2017 at 2:56 am
Hi All,
We are going to migrate the primary server from cloud to another datacenter, in the primary server all the databases we configured log shipping and secondary server to be continued the same.
After migrating we need to reconfigure by deleting the secondary server database or we can configure with the same existing standby database. If there is a chance please explain.
Kindly help on this.Thanks you.
Regards
Narendran M
September 7, 2017 at 4:48 pm
Narine M - Tuesday, September 5, 2017 2:56 AMHi All,We are going to migrate the primary server from cloud to another datacenter, in the primary server all the databases we configured log shipping and secondary server to be continued the same.
After migrating we need to reconfigure by deleting the secondary server database or we can configure with the same existing standby database. If there is a chance please explain.
Kindly help on this.Thanks you.
Regards
Narendran M
Which way you go depends. Do you even want the secondary to become the primary? Is the hardware, OS up to the task and the same as the primary? Do you have any time constraints to perform all of this? Is it feasible to get rid of all the log shipping and recreate it after all the moves?
A lot of people will just have the secondary become the primary and there are also steps to consider in the process of switching roles. Plenty of things to consider and you are likely the best one to make that decision. You could search on: log shipping changing roles
and find a lot of pieces of information.
The following articles outline some of the tasks to perform when changing the roles between primary and secondary:
Change Roles Between Primary and Secondary Log Shipping Servers (SQL Server)
Fail Over to a Log Shipping Secondary (SQL Server)
MS SQL Server – Reverse Log-Shipping
Sue
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply