I have been trialling Veeam 4.1.1 and I have to say I'm very impressed and I am hoping to get the green light for purchase. From my point of view as administrator of the virtual infrastructure and all of our VMs it does exactly what I want it to do. Our SQL DBAs on the other hand are not yet fully convinced.
Our plan is to back up our whole virtual infrastructure with a single backup solution and all backup/restore jobs are controlled by the VI admins. Currently our DBAs operate the SQL backups using native SQL backup on our SQL server VMs - Full backup every night and transaction log backups every 15 minutes. From this they can recover to any point in time using the transaction log backups and they say we are not getting the same level of flexibility with the Veeam backups.
The server I am backing up is Windows Server 2008 x64 with SQL Server 2008 x64. The SQL VSS Writer service is installed and running and "Enable Veeam VSS integration" is ticked in the backup job and the backup job is running every 15 minutes.
The issues I am having are:
- 1. The SQL transcation logs are not being truncated after backups. I understand this is a function of the SQL VSS writer but I don't understand why this is not happening.
2. I/O is frozen on the databases for about 10 seconds during the backup. I suspect this is also down to the SQL VSS writer but our sw dev guys insist that this will cause problems going forward so I really need to find a way to reduce this freeze time.
3. Is there any way of performing differential SQL backups? The SQL VSS writer includes this functionality but is there any way to get the Veeam VSS integration to tap into this, using powershell scripts for example?
4. If differential SQL backups are not possible will there be any provision for this in Veeam version 5?
5. Is there a way to restore to a point in time in between the Veeam full backups, perhaps by backing up the drive containing the transaction logs seperately?
Thanks in advance