I came to work today and I saw the transaction log with 441GB, using almost all disk space. I use SQL Server 2012 and have Full backup, but somehow I lost control of the t-log. So, I need to do 2 things: first, clear the log, so I have the disk space back and control it. I thought to control it doing daily backups. But I just can't figure how to reduce it. Shriking is not a good thing to do, and anyway will take AGES to do it. I've try to bakcup the log like this: Backup Log DB_1 TO DISK = 'Nul:' but nothing changed. So what exatcly can I do to fix this situation?
Thank you!
