Post reply

Will able to shrink MSDB - Log Shipping

  • June 13, 2013 at 4:36 am

    #278566

    Experts,

    In our production server MSDB database growing very huge can we shrinking the log and data files but in that respective server log shipping configured and its working successfully around 700 databases.

    Is it having any impact log shipping configuration when we going to shrinking MSDB files?

    So pls advice to do further.

    Pradeep

  • June 13, 2013 at 6:07 am

    #1623641

    Shrinking MSDB will not affect your Log Shipping setup. You're not deleting any data from MSDB

  • June 13, 2013 at 6:09 am

    #1623643

    Thanks for your quick reply, shall i shrink both MSDB data and log file as well?

    Pradeep

  • June 13, 2013 at 6:11 am

    #1623647

    That's up to you

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

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