Avatar of mjburgard
mjburgard
Flag 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.
Microsoft SQL Server 2008

Avatar of undefined
Last Comment
mjburgard

8/22/2022 - Mon
Vikas Garg

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.
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....
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
Vitor Montalvão

Can you check if SQL Server service account also has permissions on the shared folder?
mjburgard

ASKER
It does as well
ASKER CERTIFIED SOLUTION
mjburgard

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
mjburgard

ASKER
This was what fixed the issue - not suggested by anybody else....
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.