Post reply

Simple recovery mode and log file

  • December 3, 2009 at 5:17 am

    #213150

    Hi all

    I have a database in simple recovery mode which seems to also have a log file of 3.5gig. Wether the recovery mode has been changed from full in the past I do not know, however I do know we need this to be in simple recovery mode.

    If I want to free up the space used by this log file what is the best thing to do?

    Thanks

  • December 3, 2009 at 5:24 am

    #1087001

    best thing to do? read this article

    http://qa.sqlservercentral.com/articles/64582/

    If you really need the drive space see dbcc shrinkfile in BOL, but think carefully about how you size the log file

    ---------------------------------------------------------------------

  • December 8, 2009 at 11:02 am

    #1089370

    check and see if there are still open transaction in the database. dbcc opentran.

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

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