Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Backup - 2000

 
   Database Forums (Home) -> Replication RSS
Next:  Order by Measure  
Author Message
CLM1

External


Since: Sep 24, 2004
Posts: 66



(Msg. 1) Posted: Fri Feb 01, 2008 10:46 am
Post subject: Backup - 2000
Archived from groups: microsoft>public>sqlserver>replication (more info?)

I've got a distibutor server, 1 publishing server and 3 subscribing servers
all on SS 2000 SP4 with transactional immediate replication. What I want to
know is this: 1) what is the "best practices way" to back up the distributor
and 2) if the server melted down, what is order and procedures for doing
restores on the distributor server?
I guess you could script everything and use that as backups, right? But
that seems a little more scary for some reason to me...
Any information is much appreciated. And, of course, I don't mind reading
if you can send me to the right place!

 >> Stay informed about: Backup - 2000 
Back to top
Login to vote
Paul Ibison1

External


Since: Mar 01, 2004
Posts: 640



(Msg. 2) Posted: Mon Feb 18, 2008 9:34 pm
Post subject: Re: Backup - 2000 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

There's plenty of info in BOL for this at "Strategies for Backing Up and
Restoring Transactional Replication"
http://msdn2.microsoft.com/en-us/library/aa237094(SQL.80).aspx.
Personally, what I tend to do is regularly script out replication, and if
the publisher/distributer server goes AWOL, I aim to reset it up from
scratch using a recent backup, apply my script (modified if the new server
name is different) then reinitialize.
Rgds,
Paul Ibison (www.replicationanswers.com)

 >> Stay informed about: Backup - 2000 
Back to top
Login to vote
Display posts from previous:   
   Database Forums (Home) -> Replication All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]