sql2008 push replication

  • I'm not able to get transaction log space released on the subscription server. The log continues to grow and can't be shrunk. Checkpoint does nothing. The log_wait_desc for the replication db on the subscriber shows 'REPLICATION'. Replication is working and I know there are no more rows to be replicated. Using simple recovery mode on the subscriber because we use snapmanager for backups. Tried running the sp_repldone command manually but did not help. Anyone know how I can clear my log file ?

  • For 2005, with recovery mode in simple, you should be able to just run

    BACKUP LOG db_name WITH TRUNCATE_ONLY

    DBCC SHRINKFILE (LogicalFileName, Size)

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply