Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Location
    France
    Posts
    3

    Unanswered: file ldf too BIG

    Hi all!

    I would like to reduce the size of MyDataBase_Log.ldf
    I use Sql Server 2000.
    If it was possible which procedure i have to follow?

    Thanks

    FractalBlue

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Do you have any maintenence going on?

    You need to Dump the log and truncate at checkpoint

    Then lookup DBCC SHRINKFILE

    in BOL
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •