Backup Distribution DB ?

Should you backup the distribution database? If yes how
often?
Thank You,
Mike
Mike,
it depends on the type of replication. It's important for all kinds, but
snapshot and merge can be more easily recovered with an older backup of the
distribution db as it is not used for data. This is most important for
transactional replication, where using the sync with backup option ensures
the distributor backups can't get ahead of the production backups. In BOL
there is a useful topic on "Backing Up and Restoring Replication Databases"
that may help.
Regards,
Paul Ibison
|||In general it is a good practice.
However restoring an old copy of the distribution database into a production
system will cause your log reader and distribution agents to fail.
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:6d0d01c42f04$4a1373e0$a301280a@.phx.gbl...
> Should you backup the distribution database? If yes how
> often?
> Thank You,
> Mike
|||Only if you are using transactional.
If you are using merge, there are no log reader or distribution agents. If
you are using snapshot, there is no log reader.
Mike
Principal Mentor
Solid Quality Learning
"More than just Training"
SQL Server MVP
http://www.solidqualitylearning.com
http://www.mssqlserver.com
|||good point - I missed that!
"Michael Hotek" <mhotek@.nomail.com> wrote in message
news:Oo1DGICMEHA.268@.TK2MSFTNGP11.phx.gbl...
> Only if you are using transactional.
> If you are using merge, there are no log reader or distribution agents.
If
> you are using snapshot, there is no log reader.
> --
> Mike
> Principal Mentor
> Solid Quality Learning
> "More than just Training"
> SQL Server MVP
> http://www.solidqualitylearning.com
> http://www.mssqlserver.com
>

Backup Distribution Database

Should a distribution be backup?
Thank You,
Mike
Yes, it should be backed up. How frequently depends upon the method of
replication. If you are using merge replication, I backup the distribution
database once and never do so afterwards simply because it doesn't store
anything necessary for merge except that it has to exist. For
transactional, please see the BOL topic on "Synch With Backup".
Mike
Principal Mentor
Solid Quality Learning
"More than just Training"
SQL Server MVP
http://www.solidqualitylearning.com
http://www.mssqlserver.com