x

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?

more ▼

asked Nov 13, 2009 at 07:06 PM in Default

avatar image

Jim Orten
646 8 10 13

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.

more ▼

answered Nov 13, 2009 at 09:19 PM

avatar image

Steve Jones - Editor ♦♦
5.2k 79 93 87

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x508
x377
x247

asked: Nov 13, 2009 at 07:06 PM

Seen: 1103 times

Last Updated: Nov 13, 2009 at 07:06 PM

Copyright 2017 Redgate Software. Privacy Policy