Thank you for your input David. I have tried to do that as you indicated, and SQL indicates that it was successful, but the log file is still over 74GB!!
I went back into the taskpad and looked at the space allocated. the Transaction log is listed at 72GB with only 499 MB being used (i.e. 71.8 GB is free).
I have done full backups of the transaction log, which is also supposed to truncate the log.
I have shrunk the log file multiple times (it gets a little smaller each time - about 3 GB).
Should it be this hard? Is my log file corrupted? Any suggestions?
Again, thank you in advance.
Thank You
Rollin Burr
Politicians and diapers have one thing in common. They should both be changed regularly, and for the same reason.
