Link to home
Create AccountLog in
Avatar of mjburgard
mjburgardFlag for United States of America

asked on

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).

Open in new window


Is the application error code.
Avatar of Vikas Garg
Vikas Garg
Flag of India image

HI,

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.
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?
Avatar of 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....
Can you check if SQL Server service account also has permissions on the shared folder?
It does as well
ASKER CERTIFIED SOLUTION
Avatar of mjburgard
mjburgard
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
This was what fixed the issue - not suggested by anybody else....