SQL Server Performance

Shrinking the MSDB logs

Discussion in 'SQL Server 2005 General DBA Questions' started by carloarango, Oct 1, 2010.

  1. carloarango New Member

    the MSDB log is about 15 GB whereas the data file is only 6 GB. Is there a way to shrink the MSDB log?
    Thanks
    carloarango, Oct 1, 2010
    #2

  2. Luis Martin Moderator

    You can shrink files using SSMS. Rick click on Msdb, shrink, files and choose log.
    Luis Martin, Oct 1, 2010
    #3

  3. MohammedU New Member

    Make sure your MSDB is not in FULL recovery mode.
    If it is is in FULL recovery mode, change it SIMPLE before shrink it.
    MohammedU, Oct 13, 2010
    #4

  4. ashish287 New Member

    by default system database are in simple recovery mode. So you will not requried to shrink log as long you havent changed it to full.
    ashish287, Oct 18, 2010
    #5

Share This Page