Backup Failed for Server.
Applies to: Microsoft SQL Server 2005 Express Edition.
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)
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)
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.
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.