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 […]
If you've changed your Operating System hostname, you should reflect that change in SQL Server by updating the name in the Master database. SQL Server doesn't support updating the name when involved in database mirroring, replication, or clustered environments. You'll have to remove the feature, update the name, then re-add the feature.