Backups

I have transactional replication topology where each component is on
its own server. I currently backup the t-logs every 15 minutes with a
differential at noon and a full back up at midnight.
Is it necessary for me to create the exact same backup strategy at the
distributor and subscriber? Or would a full backup with less frequent
t-log backups be sufficient for the distribution and subscription
databases?As you did not mention which version of your SQL Server, I'll post 2
choices.
There is an article about "Strategies for Backing Up and Restoring
Transactional Replication" for SQL Server 2000 in Books Online. You may want
to check it out?
http://msdn2.microsoft.com/en-us/library/aa237094(SQL.80).aspx
And this is for SQL Server 2005:
http://msdn2.microsoft.com/en-us/library/ms152560.aspx
--
Ekrem Önsoy
"NC3" <ncoleman3@.yahoo.com> wrote in message
news:1191534232.786974.23060@.o80g2000hse.googlegroups.com...
>I have transactional replication topology where each component is on
> its own server. I currently backup the t-logs every 15 minutes with a
> differential at noon and a full back up at midnight.
> Is it necessary for me to create the exact same backup strategy at the
> distributor and subscriber? Or would a full backup with less frequent
> t-log backups be sufficient for the distribution and subscription
> databases?
>