Reducing size of MS SQL transaction log file.
Posted on 2013-10-23
I need to reduce the size of the transaction log file for MS SQL 2008 R2 database. Tech from app vendor directed me to shrink log file, as well as switch to Simple Recovery mode. Shrinking the log file freed up some space, though not a lot. Current size is 192GB. After reading MS docs on MS SQL 2008, I understand the correct way to go about the whole process. Backups were never setup for the transaction log, so it never was cleared. I guess there are 3 plus years worth of transactions.
Unfortunately, I switched Recovery mode to Simple, before verifying info. Is it possible to switch back to Full mode, and then perform Full backup of transaction log? Will the backup clear out the unneeded data? Is there another way to accomplish clearing out the transaction log? Does SQL still use the transaction log in Simple Recovery mode? Can I just delete it without suffering any harm to the database operation?
All Help is greatly appreciated.