Recovering Distribution Database

Last Post 03 May 2007 07:52 PM by shirishrangnekar. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
jstiebe
New Member
New Member

--
19 Apr 2007 10:18 AM
I am running Transactional Replication. If I have a Publisher server, Distributor server, and 14 Subscriber workstations, what is the best way to recover the Distribution database in case of disk failure, server blows up, etc. Should I be backing up the Distribution database regularly? After recovering it, will I need to re-deply snapshots to all subscribers or will Distribution database resync with Publisher and Subscribers?
shirishrangnekar
New Member
New Member

--
03 May 2007 07:50 PM
You need to setup a backup of distribution database in sync with the publisher. This way you can restore the databases in case of a crash and you dont need to reinitialize the replication.
shirishrangnekar
New Member
New Member

--
03 May 2007 07:52 PM
You are not authorized to post a reply.

Acceptable Use Policy