niomlog.blogg.se

Ensure that you enabled Windows authentication for your SQL servers.

To know how you can configure VSS to write shadow copies to a separate drive, see Set VSS to write shadow copies to a separate NTFS volume. Ensure that the disk space on the drive where your shadow copy storage is located is adequate for the cumulative size of your databases.Ensure that the SQL Writer Service on your MS-SQL servers is running.If you are using a third-party VSS provider, you must configure Hybrid Workloads agents to recognize this provider. If differential and transaction log backups and restores are not required, sysadmin permissions are not required. For more information, see SQL Server VDI backup and restore operations require Sysadmin privileges.ĭruva recommends that you use the Microsoft’s native VSS provider. If the user account used for SQL VDI differential backups does not have the sysadmin role, the backups will fail in the initial stages. The SysAdmin role is mandatory for VDI backups and restores. Note: As with any other third-party backup software, Druva interfaces with Microsoft Virtual Device Interface (VDI) to perform differential and transaction log, backups and restores. For more information, see GRANT Database Permissions. If the account used for SQL backups and restores does not have the CREATE DATABASE permission, the restores may fail with the SQL7 error. The account used for SQL backups and restores must also have the CREATE DATABASE permission for successful restores from snapshots. The Hybrid Workloads agent uses Microsoft SQL Server Virtual Device Interface (VDI) for differential and transaction log backups. Ensure that the Volume Shadow Copy Service is not disabled. The Hybrid Workloads agent interacts with Volume Shadow Copy Service (VSS) to perform full backups.