Cannot setup a maintenance backup on sql server after migration to another physical server
We migrated our database to another physical server. I can backup the database as a one time backup with no problems. However, when I try to create a maintenance task to backup the database, it fails. It does not matter where I try to backup to, local or network - it fails.
SQL Server Scheduled Job 'MaintenancePlan.Subplan_1' (0xF8A03D1AD115CE479F49E0EFBD6F69C3) - Status: Failed - Invoked on: 2015-10-08 09:03:36 - Message: The job failed. The Job was invoked by User COLORWORLD\brettd. The last step to run was step 1 (Subplan_1).
It seems more of access rights issue.
The SQL Job owner account should have rights to the directory where the backup is to be done.
The SQL Job owner should also have access to the database also.
Vitor Montalvão
Isn't the SQL Job owner that need to have permissions on the target folder but the SQL Server Agent account. Did you change the SQL Server and SQL Agent accounts in the new server?
mjburgard
ASKER
Thanks to both of you, but the account that runs the sql server agent has sufficient permissions to write to any shared folder on the network....
It seems more of access rights issue.
The SQL Job owner account should have rights to the directory where the backup is to be done.
The SQL Job owner should also have access to the database also.