Changing DB from Full to Simple Recovery - and how to truncate the current transaction log to free space
Posted on 2011-10-16
Can someone please help or point to instructions on how to #1 truncate the current transaction log which is too large and #2 change the database to SIMPLE recovery from FULL. (should the current log be truncated first and then the database recovery changed, or will the process of change the recovery mode truncate the log. Also, will truncate automatically reduce the log size, or will it need a 'shrink' process to get it back to a acceptable size?) If multiple steps, please direct me to the correct order - much appreciated.