[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

 
Backup Failed for Server

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
Open Source
Security
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
SQL Server 2017
SQL Server 2019
Tips
Troubleshooting
Tuning

Backup Failed for Server.


Applies to: Microsoft SQL Server 2005 Express Edition.

 

Error Message
 

When we tried to backup a database using a logical backup device that represents a disk file, we received the following error:


Backup failed for Server 'servername'. (Microsoft.SqlServer.Smo)

Additional information:

System.Data.SqlClient.SqlError:  Cannot open backup device.
'LogicalBackupDeviceName (C:\Program files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\folder1\DB.bak').  Operating system error 5(Access is denied.).(Microsoft.SqlServer.Smo)





 

Cause

The service account for the MSSQLSERVER service does not have permissions over the physical file or folder on the hard drive that corresponds to the logical backup device that is being used to make the database backup.


Solution


Please make sure that the SQL Server Service account has modify permissions over the physical file or folder on the hard drive that corresponds to the logical backup device.


 

 

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.