December 3, 2003 at 3:40 am
Is it necessary to backup the distribution database?
Rob
December 3, 2003 at 9:29 am
I'd say its a good idea, just depends on your recovery plan. Mine is that if distribution db drops, I'll resnapshot everything. Clumsy perhaps, but simple. Snapshot not always doable or desirable - if that is the case, then you want to have the ability to restore distribution. Even though I dont plan to use it, I back it up anyway.
Andy
December 4, 2003 at 6:15 am
hi!
depends on how complex your replication environment is. the more complex, the more "yes" i'd suggest.
best regards,
chris.
October 25, 2006 at 12:03 pm
We had a situation where the network admin accidentally un-installed SQL on the publishing server. We had no current backup of the distribution database, so all the transactions pending to get pulled to the subscriber were lost. I'm thinking it would be good to change the distribution DB to FULL, and run t-log backups frequently.
Thoughts ?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply