Jpotucek (4/17/2013)
I have a Database (about 1GB) with 2 log files (one at about 4GB and one at about 13 GB)The database had been set to Full recovery mode but there were no regularly scheduled TLOG backups running.
I'd like to reclaim some of the space back to the OS from the log file. I ran a couple of TLOG backups and a full backup. Now I'd like to shrink the logs. How would I go about doing that?
You are not taking a t-log backup then is there any reason to place a DB in full recovery.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/