I am trying to backup my database but it is failing with the following error: BackupDiskFile::CreateMedia: Backup device '\System\master_backup_2012_06_08_113121_5537116.bak' failed to create. Operating system error 5(Access is denied.).
I am able to manually write to the location. The SQL Agent job is the same ID that is able to manually write to the location. Also, the ID is a sysadmin on the DB.
The issue is with the permissions to the folder where you are trying to take backup. Operating system error 5 clearly indicates that the sql server service account doesn't have permissions on the specified folder.
Your backup is running in the context of SQL Server - you need to grant permissions for the account running SQL Server.
As stated above, SQL is running with a service account that has access to the shared. I tested this by manually creating a file and folder and was also able to delete.
As stated above, SQL is running with a service account that has access to the shared. I tested this by manually creating a file and folder and was also able to delete.
So you logged in with the service account under which SQL service runs and then created the file/folder on the shared path.
After Monday and Tuesday even the calendar says W T F ....
As stated above, SQL is running with a service account that has access to the shared. I tested this by manually creating a file and folder and was also able to delete.
So you logged in with the service account under which SQL service runs and then created the file/folder on the shared path.
After Monday and Tuesday even the calendar says W T F ....
Run the backup command and check the security/application error log of the network path at the instance the backup command is running.Also are you logged in as a sysadmin on the sql instance while running the backup command ?
Between what version of SQL Service is it ?
After Monday and Tuesday even the calendar says W T F ....
Backup Failed
Posted - 06/08/2012 : 12:00:38
