Someone has asked me a question about backups and it has been too long since I have worked with MSSql. He has an application that has about 50 databases and there is a script that runs every night to back everything up except, he has not been truncating the logs. No they are about to run out of disk space and need to recover most of the space used by the logs. Here one line of the script he is using now.
BACKUP DATABASE DATABASE_1 TO DISK = 'd:\SQLBACKUP_day1\DATABASE_1.bak' With INIT
It is my understanding that "truncate log" does not shrink the file. How can I automate the shrink file as well?
Thanks.