REVERSE LOG SHIPPING
====================1.Disable the log shipping backup job on the primary server.
2.On the standby server, run the log shipping copy and restore jobs to restore any remaining transaction log backups.
3.Disable the log shipping copy and restore jobs on the secondary server.
4.On the primary server, create on last transaction log backup using the NO RECOVERY option.
5.On the standby server, restore this transaction log backup using the RECOVERY option.
6.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.
I admire this article for the well-researched content and excellent wording. I got so involved in this material that I couldn’t stop reading. I am impressed with your work and skill. Thank you so much. https://idealspy.com/
ReplyDeleteThanks for your post. I’ve been thinking about writing a very comparable post over the last couple of weeks, I’ll probably keep it short and sweet and link to this instead if thats cool. Thanks. https://europa-road.eu/hu/gepszallitas.php
ReplyDeleteI think that thanks for the valuabe information and insights you have so provided here. Korea package forwarding
ReplyDeleteThanks for taking the time to discuss this, I feel strongly about it and love learning more on this topic. If possible, as you gain expertise, would you mind updating your blog with extra information? It is extremely helpful for me. FBA shipping
ReplyDeleteSea freight shipments will take a longer period of time than air or rail freight, but it is often a more economical option. Europa-Road
ReplyDeleteplease provide me P1& P2 ..... any one of the issue and how to resolve in step by step
ReplyDelete