I have an SQL server database and the log file has grown to a fantastic 10GB. Obviously I need to reduce this as disk space is not infinite. I have read around the internet and I understand that by backing up the log it will reduce the log file size.
I have thus used the BACKUP LOG SQL command and it has been backed up, however the log file is still 10GB, how can I get this down?
Btw suggesting a bigger hard disk won't get the 500 points... :-)
Any help greatly appreciated.