Wednesday, March 7, 2012

backups getting huge

Is replication suppose to continually grow the database backups on the
distribution machine? I had to remove replication because the backups grew a
couple gig in about a months time. Am I missing something? I've tried this
twice now with the same results. Thanks.
for merge it may. For transactional it shouldn't if your log reader agent is
running frequently.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"s" <s@.discussions.microsoft.com> wrote in message
news:9B0AD4A6-D102-486C-9FAF-9091B954E9A3@.microsoft.com...
> Is replication suppose to continually grow the database backups on the
> distribution machine? I had to remove replication because the backups grew
a
> couple gig in about a months time. Am I missing something? I've tried this
> twice now with the same results. Thanks.
|||Thanks for the reply. I was using snapshot replication. Would this also
create continually growing backups? Is there any way to get around this
effect?
"Hilary Cotter" wrote:

> for merge it may. For transactional it shouldn't if your log reader agent is
> running frequently.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "s" <s@.discussions.microsoft.com> wrote in message
> news:9B0AD4A6-D102-486C-9FAF-9091B954E9A3@.microsoft.com...
> a
>
>

No comments:

Post a Comment