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.