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.  

1 comment:

  1. repair sql database has necessary probabilities for solving out issues related to corrupted or lost mdf files. It restores .mdf after power failures, hacker attacks. The tool starts under all available MS Windows working with big .mdf files too.


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...