Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

SQL Server VDI backup and restore operations require Sysadmin privileges


View products that this article applies to.

Summary

Backup or restore operations that use the Microsoft SQL Server Virtual Device Interface (VDI) require that the server connection for SQL Server that is used to issue the BACKUP or RESTORE commands must be logged on as the sysadmin fixed server role. This may not be desirable in all environments and may cause third-party backup applications that use VDI to fail if the service accounts of the applications are configured to only have the db_backupoperator fixed database role. This is a design limitation in the current versions of SQL Server.

↑ Back to the top


More Information

The VDI connection requires the Sysadmin permission because the connection itself is capable of executing more than simple backup operations and involves shared resources between the client and server.  The Microsoft SQL Server product team is evaluating this requirement for the next major version of SQL server, and this Microsoft Knowledge Base (KB) article will be updated when additional information is available.

For additional information about SQL Server backup and restore operations, consult the following Microsoft TechNet webpage:For additional information about Volume Shadow Copy Service (VSS) and VDI backups in SQL server, consult the following MSDN blog post:Application vendors can consult the following guide for additional information about using VSS for SQL server backups:

↑ Back to the top


Keywords: kb, kbsurveynew, kbprb, kbexpertiseinter

↑ Back to the top

Article Info
Article ID : 2926557
Revision : 1
Created on : 1/7/2017
Published on : 3/1/2016
Exists online : False
Views : 519