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.
Is the application error code.
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).Is the application error code.
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?
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....
Can you check if SQL Server service account also has permissions on the shared folder?
ASKER
It does as well
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This was what fixed the issue - not suggested by anybody else....
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.