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.

Solution

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.

    ReplyDelete

How to fix cardinality estimation anomalies [Video]

Use the link mentioned below to watch the presentation that I delivered for PASS DBA Virtual Chapter about Filtered Statistics.  http:...