Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
iminore
Posting Yak Master
141 Posts |
 Posted - 2006-09-13 : 10:08:09
|
| Has anyone had any experience of moving a publishing database to a new server. Apart from backing up and restoring the publishing database some guidance would be appreciated. |
|
|
Rishi Maini SQL2K5 Admin
Yak Posting Veteran
80 Posts |
Posted - 2006-09-14 : 10:35:27
|
| What are your intentions? Is it that you want to scrap the old Publisher and create a new one without breaking Replication ?If that is the case there are too many things that you need to take care of. If yes let us know so that we can assist further with the Action Plan.Otherwise if its just that you want to restore a Published Database to a new Server than you can certainly go for it but run "sp_removedbreplication" SP on the Restored Database to remove any kind of left over tarces of Replication from the restored DB.ThanksRishi Maini |
 |
|
|
iminore
Posting Yak Master
141 Posts |
Posted - 2006-09-14 : 16:16:58
|
| It's the former - moving a transactional replicated db to a new server. Dropping the old server and maintaining replication. |
|
|
|
Rishi Maini SQL2K5 Admin
Yak Posting Veteran
80 Posts |
Posted - 2006-09-16 : 04:54:20
|
| This is what you need to do:- 1. Copy the MDF and the LDF files for all the Databases from your Publisher Box.2. Unplug the Network Cable of the Publisher and remove the Box name for this Publisher from Active Directory.3. Rename your new Box so that this new Box name = Old Publisher Box name.4. Install SQL on this new Box (Note keep the path of the MDF and LDF for system databases exactly the same as it was there in your old server). 5. Get SQL to the build that it was earlier on.6. Swap the MDF and LDF for the System and the user Databases and restart the services and you are ready to go.Only challenge is that you need to create a exact copy of your old server (Network Name and Database file locations) while configuring your new Server.Its your call if you want to go for this option without breaking the existing replication or think again if its worth setting up the replication again on the new Box from scratch.ThanksRishi Maini |
|
|
|
|
|
|
move publisher to new server