Post reply

Truncating log in the transactional Replication on sql server 2008.

  • November 9, 2011 at 3:26 am

    #259657

    Yesterday Night I faced Issues on Transactional Replication.

    We have sql server 2008 r2 setup with transactional replication with pull subscription,

    Suddenly our database system is down. Due to in-sufficient in the transactional Log.

    After the Full Backup and transactional Backup on the transactional Replication database, Now the system are up and running fine.

    Can i know the any information regarding the backup strategies on Transaction Replication.

    How can i truncate transaction log in the transaction replication.

    Please Help me..

  • November 9, 2011 at 3:36 am

    #1405057

    You can backup your log but it wont truncate if log truncation is waiting for replication.

    If the recovery mode is full, schedule regular log backups. See if transactional replication is moving data to distributor, if not, log truncation will not be possible and your log file will continue to grow.

  • November 10, 2011 at 6:35 am

    #1405705

    Whether the DB is in replication or not, you have to have a strategy to manage your log files. Gail Shaw has written a good article on managing the log files. Take a look at this article written by Gail[/url].

    -Roy

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

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