I have question regarding Veeam SQL plugin.
Durring the backup the creation of VDI (virtual device interface) is created to utilize backup process.
My question is where this VDI is stored. is it short-term in RAM, or local disk or it's presented to SQL as Veeam Backup repositories, so data is stored directly to repositories.?
This question is raised by client, as they want to know if creation of db backup will fill out their local filesystem.
Thanks
The VDI device is stored in RAM on the SQL Server and our plug-in fetches data from this device. You may find more information about VDI in this section on Microsoft Learn. The RAM/CPU requirements depending on the number of streams are described on this page of our user guide.
To add to this, that the CPU requirements are an estimated value based on customer and lab feedback.
The plug-in is capable to handle more than 10GB/s (yes Byte) backup throughput (if source disk, network and backup target is fast enough) and the faster the backup the more compression/checksum/hash generation will consume more CPU power.
I don't want to create a separate thread but facing access/rights issue for MS SQL Plugin backup, despite of having confirmed Sysadmin/public roles and account is part local administrator group it still shows errors that
Access denied. You must be logged in as Windows Administrator to create a virtual device. failed to start VDI Backup.
related thing is when double click the plugin utility, the wizard is populated with local instance and its DBs but when i execute Run As Administrator ( no password ) is prompted but the plugin wizard loads other instance of the cluster but no DBs.
