- > Connect to the instances-PRI Server and Secondary Server
-> Disable the log shipping backup job on the primary server.
-> On the standby server, run the log shipping copy and restore jobs to restore any remaining transaction log backups.
-> Disable the log shipping copy and restore jobs on the secondary server.
-> On the primary server, create on last transaction log backup using the NORECOVERY option.
-> On the standby server, restore this transaction log backup using the RECOVERY option.
-> On the standby server (which will now be the primary server), right click on the database and select Properties
-> Transaction Log Shipping. Enable the database to become the primary database and configure the backup and secondary server settings.
No comments:
Post a Comment