SQL Server VDI backup and restore operations require Sysadmin privileges

Extended support for SQL Server 2005 ended on April 12, 2016

If you are still running SQL Server 2005, you will no longer receive security updates and technical support. We recommend upgrading to SQL Server 2014 and Azure SQL Database to achieve breakthrough performance, maintain security and compliance, and optimize your data platform infrastructure. Learn more about the options for upgrading from SQL Server 2005 to a supported version here.

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.
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:
Properties

Article ID: 2926557 - Last Review: 03/01/2016 19:42:00 - Revision: 2.0

Microsoft SQL Server 2005 Enterprise X64 Edition, Microsoft SQL Server 2005 Service Pack 4, Microsoft SQL Server 2005 Standard Edition, Microsoft SQL Server 2005 Standard X64 Edition, Microsoft SQL Server 2008 Enterprise, Microsoft SQL Server 2008 R2 Datacenter, Microsoft SQL Server 2008 R2 Enterprise, Microsoft SQL Server 2012 Developer, Microsoft SQL Server 2012 Enterprise, Microsoft SQL Server 2012 Service Pack 1, Microsoft SQL Server 2012 Standard, Microsoft SQL Server 2008 Service Pack 3, Microsoft SQL Server 2008 Standard, Microsoft SQL Server 2014 Developer, Microsoft SQL Server 2014 Enterprise, Microsoft SQL Server 2014 Enterprise Core, Microsoft SQL Server 2014 Standard, Microsoft SQL Server 2014 Web

  • kbsurveynew kbprb kbexpertiseinter KB2926557
Feedback