Results 1 to 3 of 3

Thread: Can't shrink log problem sql 2000

  1. #1
    Join Date
    Nov 2002
    Posts
    261

    Can't shrink log problem sql 2000

    I have a client db that has a transaction log of over 38 gig. I backed up the db, backed up the log, and even truncated the log. It will not let me shrink the DB log file.

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Try switch to simple recovery mode then shrink, and ensure there is no open transaction in the db. Siwtch recovery mode back and do another full backup afterwards. Did your client ever backup log?

  3. #3
    Join Date
    Nov 2002
    Posts
    261
    Yes, they had a runaway job which created a huge file and mess. Had to restart sql and it let me shrink log, however on reboot it had to read the entire log file which took over an hour

Posting Permissions

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