Post reply

My Modelog.lgd file is too large

  • July 17, 2009 at 2:28 pm

    #1026444

    Thanks Jeffrey.

    You are right. I need to find it out what's going on my model db.

    For now I follow the instructions and I recover my server space.

    Do you thing that I should make my model db read only and keep recovery model simple?

    Thanking You again.

    Maksuda...

  • July 17, 2009 at 2:42 pm

    #1026449

    For now I would set the model DB to the simple recovery mode and read only. Something will start throwing errors when it can't write to the database.

  • July 17, 2009 at 3:21 pm

    #1026459

    Thanks a lot Steve.

    Maksuda...

  • July 20, 2009 at 6:19 am

    #1026878

    Jeffrey Williams (7/17/2009)

    Jason Shadonix (7/17/2009)

    If I'm counting over to the right column, then for the data file you have 856 Pages (under 8MB) and only have 96 Pages (< 1MB) in the log file.

    That is correct for the MSDB database. However, the problem for the OP is the MODEL database - and specifically the model log file.

    Doh! Sorry about that!

    The Redneck DBA

Viewing 4 posts - 31 through 33 (of 33 total)

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