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.  

How to interpret Disk Latency

I was analyzing IO stats in one of our SQL Servers and noticed that IO latency (Read / Write) are very high. As a rule of thumb, we know tha...