Results 1 to 3 of 3

Thread: .ldf log file

  1. #1
    Join Date
    Mar 2003
    Location
    SJ, Costa Rica
    Posts
    48

    Unanswered: .ldf log file

    Hi everybody, I have a 10.2Gb .ldf file that is giving me hard disk space problems. We already empty the file with the Enterprise Manager, but the file
    still weigths the same...
    Is there any procedure shrink this file??
    thanks in advance

  2. #2
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    Quote Originally Posted by midget
    Hi everybody, I have a 10.2Gb .ldf file that is giving me hard disk space problems. We already empty the file with the Enterprise Manager, but the file
    still weigths the same...
    Is there any procedure shrink this file??
    thanks in advance
    go to the database in question, type in CHECKPOINT. Wait a little while, then run a shrinkdb. If you are not going to be doing log backups, you need to set the recovery mode to Simple so you don't keep having trouble with this though. After you set it to simple, you can run a shrinkdb and you'll be fine.
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

  3. #3
    Join Date
    Mar 2003
    Location
    SJ, Costa Rica
    Posts
    48
    thanks,!
    that worked pretty good...
    regards,

Posting Permissions

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