question

Jim Orten avatar image
Jim Orten asked

What's the best way to backup replication in SQL Server 2000?

We are running transactional replication on SQL Server 2000. Subscribers, publishers and distributor are all on different servers. What's the best way to backup replication so that it could be rebuilt on either the subscriber, publisher or distributor?

sql-server-2000replicationbackup
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Steve Jones - Editor avatar image
Steve Jones - Editor answered

You can script out the replication setup, which is your best bet. Be sure that you note where server names are used in case you need to change the names later.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.