Groups | Blog | Home
all groups > sql server replication > january 2004 >

sql server replication : Backing up replication along with the database



Rogio
1/20/2004 9:44:21 AM

Hello there!

I am preparing a new server for the databases we use ( an accounting
program using SQL Server 7.0 on a W2k Server), but the main specialist from
the accounting software maintenance team tells me there is no backup for the
replication settings, so he is very affraid he will have a lot to work to
recreate all those (dial-up) replications.
Is there really no way to backup and restore these replication settings?
Any info on this woulf be greatly appreciated.

Thanks in advance
Rogio


AVH
1/20/2004 9:50:25 AM
You normally can use pull subscriptions and, moreover, you can script most
(if not all) replication related items.

Annick


[quoted text, click to view]

Rogio
1/21/2004 5:59:13 PM
Annick

thank you very much, but me personally I don't know much about SQL server
(I'd do myself those replication setting if I knew how) so I can't
understand much of what you said to me. Please redirect me to a tutorial or
alike, I really want to understand why can be so difficult in setting those
replications. I already can backup/restore a database (manually or
scheduled), I know where to look for the file that store the database I am
looking for, but I have learned these watching him at work. This guy looks
so scared when it comes about replication, I really want to know why is this
so difficult and how can I do it myself, while I am the one that administers
the W2K server.

Thanks again
Rogio



[quoted text, click to view]

AddThis Social Bookmark Button