Post reply

Shrinking a log file

  • May 7, 2010 at 7:19 am

    #144686

    Hi,

    Will shrinking a log file will break the Logshipping process. can anyone throw some light.

    Regards,

    Sandhya

  • May 7, 2010 at 7:25 am

    #1164082

    Shrinking a log file of the primary database is not going to break log shipping. All log shipping depends on is sequential restores of the transaction log backups to the secondary database.

  • May 7, 2010 at 7:29 am

    #1164087

    Just make sure that you are not changing the recovery model in the process.

  • May 7, 2010 at 7:40 am

    #1164094

    sandhyarao49 (5/7/2010)

    Will shrinking a log file will break the Logshipping process.

    Any specific reason behind it ? i guess your log is rapidly growing.

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

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

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