Reverse SQL Server Log Shipping Roles

So you’ve configured log shipping. That’s only half of the puzzle solved. This article will show you how to reverse SQL Server log shipping roles of the primary and standby server, then reverse them again without the need of a full backup (if your primary server is still accessible). This method is very handy when you’re dealing with large databases.