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-12-19 : 11:51:03
|
| For Transactional Replication if I want to move the publisher database to a new server do I need to backup the distribution database and restore that as well?Will the new server be able to synchronise things? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-12-19 : 13:38:35
|
| Delete replication before your database moves, then rebuild replication after you are done with the move. If you made sure that all transactions made it into the subscriber prior to deleting replication, then you won't need to perform a snapshot during the rebuild.Tara Kizer |
 |
|
|
iminore
Posting Yak Master
141 Posts |
Posted - 2007-01-03 : 04:54:16
|
| Agrred.All done now, but it was a pain. The lesson was not to try to carry over replication values to new server. Create empty database on existing server and copy database to that one. Back up and restote that database to new server then create new database on new server and restore data then create replication details. |
|
|
|
|
|
|
Move publisher to new server