-
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.
-
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?
-
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
-
Forum Rules
|
|