We have a 20M database but a 140M transaction log file. Attempting to shrink the log files only gives me about 10M back. I have done tlog backups as well as full backups but the log file seems to stay the same. Would it be safe to setup the backup to simple then change it back to full after a backup? Any other solution you can recommend?
Thank you in advance.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.