You can setup a nightly incremental backup + enable log processing every X minutes. That will allow you to perform point-in-time recovery of your database server without need to perform VM backup every X minutes. It's recommended to perform periodic full VM backup, for example you can setup a job with VM nighlty incremental backup + every X minutes transaction log backup + VM Full backup every last day of the month.so in my head I think the best thing to do is use Veeam to do nightly server backup files and truncate the SQL logs.
That's only partially true. You can't prevent MSSQL from writing to log however you can prevent log file from extensive growth - please see the article.So the log file never grows. The only way SQL will write to the log file again is if I do a MS SQL backup from Management Studio.
Users browsing this forum: No registered users and 8 guests