SQL

December 2 2012

Reverse SQL Server Log Shipping Roles

Travis SQL Server, Windows Log Shipping, SQL 1

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.

November 8 2012

Change SQL Server Name

Travis SQL Server, Windows SQL 0

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.