snaphot replication huge log file issue

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sammy - 18 Aug 2008 18:36 GMT

Hi we have a database at 32 gb which is involved in snapshot replication. On
checking log sizes using dbcc sqlperf the log file for this database is
50Gb and is 91% full.

I really need to get this database log file shrunk is there anything I
should be looking at for the replication to see what the issue is.

Replication Sql server 2005 Ent > going to > Sql server 2005 ent

thanks for any help Sammy.

Reply to this Message

Hilary Cotter - 20 Aug 2008 13:59 GMT

Put the subscriber db in bulk copy mode when applying the snapshot.

To shrink the subscriber db right now, put the database in simple recovery
model , and then bulk logged and then shrink it.

> Hi we have a database at 32 gb which is involved in snapshot replication.
> On
[quoted text clipped - 7 lines]
>
> thanks for any help Sammy.

Reply to this Message

Sammy - 25 Aug 2008 09:20 GMT

Thanks Hilary

> Put the subscriber db in bulk copy mode when applying the snapshot.
>
[quoted text clipped - 12 lines]
> >
> > thanks for any help Sammy.

Reply to this Message