I've got a SQL 2008 server that is out of disk space. I'm assuming this is because a backup has never been done before and the transaction logs are out of control. The server is running in Win 2k8 R2 on an ESX host.
I've just create a new disk for the backup, but when I try to add windows backup roll, it is asking me to bounce the server because there are some MS updates that require it to, so I need to wait until end of school.
My question is - will the backup automatically truncate the transaction logs?