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.
Printable View
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