How to reduce SQL Server 2008 transaction log file
Posted on 2015-02-18
Can someone please advise?
I have a small database running on SQL Server 2008 Std in a desktop. 4-5 users use the database everyday during the week. Now, the hard drive space is reducing rapidly on the desktop. After looking at C Drive, I found the Log file has become too large ( close to 200GB). Now, I do a full backup of the database every night to an external hard drive attached to the desktop computer. I need to get the space back on that computer. Can someone please advise what would be the best way to do that?
- if I can reduce the LOG file with/without taking down the database?
- since I have full backup, can I just start refresh the Log file?
Thanks in advance.