Backup and restore of publisher

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Fast Eddie - 28 Apr 2006 14:07 GMT

We use SQL Server 2000 with merge replication with 500 users. We are moving
the server and need to temporarily move the database to a different server
while the server is moved. Is there a way to backup and restore the server
(publisher) without having to create a new replica set? Any references
would be appreciated.

Reply to this Message

Hilary Cotter - 28 Apr 2006 14:47 GMT

You might want to review Strategies for Backing Up and Restoring Merge
Replication in BOL.

Signature

Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> We use SQL Server 2000 with merge replication with 500 users. We are
> moving the server and need to temporarily move the database to a different
> server while the server is moved. Is there a way to backup and restore
> the server (publisher) without having to create a new replica set? Any
> references would be appreciated.

Reply to this Message