sql server replication: Hi,

I have Database which is configured for Transaction Replication. My Database options are "AutoShrink". I have scheduled TransactionLog Backup Job Every Hour.

I am unable to see the log is shrinking, it's growing alomost from day one.

Ours is SP3A, and Clustered.

Please advice me, for any options to be set.

do a dbcc opentrans to see if there are any open transactions.

If there are try to figure out what they are and consider killing them.

If you are doing transaction log backups each hour expect the tlog to grow.
When it is dumped it won't return to 0 bytes, but rather to a size which
reflects open transactions.

I'd also disable auto shrink as this can cause locking.


[quoted text, click to view]
Database options are "AutoShrink". I have scheduled TransactionLog Backup
Job Every Hour.
[quoted text, click to view]