Saturday, July 9, 2011

How to Move a Publisher Database

Recently I faced an incident where I needs to MOVE a database which is a publisher, to a different drive. The reason was the insufficient storage. The challenge was to intact the replication settings of the database after the move. So that, I don't have to recreate the replication which is a tedious also a boring task.

As many of you aware, there are several methods can be applied to move a database. Such as, attach / detach method, move database files while the server is shutdown, etc. However none of these methods are a solution in my case, because of the replication factor.

The version of the SQL server I am using is 2008.


Took a full backup of the database and then restored with “WITH MOVE” option to the new drive.  

Understanding Skewed Data in SQL Server

My latest article. Understanding Skewed Data in SQL Server Introduction I re...