Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

DB Backup Maintenance Plan Won't Execute Expand / Collapse
Author
Message
Posted Tuesday, July 31, 2012 3:22 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, September 24, 2013 5:00 PM
Points: 50, Visits: 161
I've created a back up plan on one DB using the Maintenance Plans Wizard and the regular way (New Maintenance Plans). Everything looks to be setup correctly but when I try to execute the plan to see if it'll run properly, the plan fails to execute giving me an "Execution failed" message. Looking at the SQL Server Agent job history it seems like my SQL Server can't determine if my Windows NT group/User ID has the appropriate server access. I'm able to do basically everything I want to inside the server but execute the maintenance plan. Does any body know how to change my server access so I can get my maintenance plans running?
Post #1338210
Posted Tuesday, July 31, 2012 3:55 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 2:50 PM
Points: 21,744, Visits: 15,435
What is the error message?



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1338223
Posted Tuesday, July 31, 2012 4:00 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, September 24, 2013 5:00 PM
Points: 50, Visits: 161
"- Execute maintenance plan. Backup Weekly (Error)
Messages
Execution failed. See the maintenance plan and SQL Server Agent job history logs for details."


There was no log file in the maintenance plan log so I checked SQL Server Agent job history and found the message stating the server access issue.
Post #1338225
Posted Tuesday, July 31, 2012 4:02 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 2:50 PM
Points: 21,744, Visits: 15,435
mrtrich99 (7/31/2012)
"- Execute maintenance plan. Backup Weekly (Error)
Messages
Execution failed. See the maintenance plan and SQL Server Agent job history logs for details."


There was no log file in the maintenance plan log so I checked SQL Server Agent job history and found the message stating the server access issue.


Please post that error (from the agent history).




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1338227
Posted Tuesday, July 31, 2012 4:07 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, September 24, 2013 5:00 PM
Points: 50, Visits: 161
SQLRNNR (7/31/2012)
mrtrich99 (7/31/2012)
"- Execute maintenance plan. Backup Weekly (Error)
Messages
Execution failed. See the maintenance plan and SQL Server Agent job history logs for details."


There was no log file in the maintenance plan log so I checked SQL Server Agent job history and found the message stating the server access issue.


Please post that error (from the agent history).



07/31/2012 14:06:30,Backup Weekly.Subplan_1,Error,0,SERVER1,Backup Weekly.Subplan_1,(Job outcome),,The job failed. Unable to determine if the owner (XX\mrtrich99) of job Backup Weekly.Subplan_1 has server access (reason: Could not obtain information about Windows NT group/user 'XX\mrtrich99'<c/> error code 0x5. [SQLSTATE 42000] (Error 15404)).,00:00:00,0,0,,,,0
Post #1338232
Posted Tuesday, July 31, 2012 4:21 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 2:50 PM
Points: 21,744, Visits: 15,435
I presume you are able to create, delete, alter files in the location referenced in the maintenance plan?



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1338238
Posted Tuesday, July 31, 2012 4:26 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, September 24, 2013 5:00 PM
Points: 50, Visits: 161
SQLRNNR (7/31/2012)
I presume you are able to create, delete, alter files in the location referenced in the maintenance plan?


yes, i was the one that created the maintenance plan. i can delete and alter that plan as well. if that is what you meant by "files in the location referenced in the maintenance plan"
Post #1338239
Posted Tuesday, July 31, 2012 4:30 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 2:50 PM
Points: 21,744, Visits: 15,435
Nope. I mean the location on disk where the maint plan is trying to access to write backups, logs, or delete files. Have you tried running the steps of the maint plan outside of an agent job?



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1338241
Posted Tuesday, July 31, 2012 4:37 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, September 24, 2013 5:00 PM
Points: 50, Visits: 161
SQLRNNR (7/31/2012)
Nope. I mean the location on disk where the maint plan is trying to access to write backups, logs, or delete files. Have you tried running the steps of the maint plan outside of an agent job?


Yup I have admin rights on the server and all drives and folders. I copied the sql script from the plan and executed on management studio and it worked fine
Post #1338246
Posted Wednesday, August 1, 2012 2:34 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 5:39 AM
Points: 2,694, Visits: 3,387
mrtrich99 (7/31/2012)
SQLRNNR (7/31/2012)
Nope. I mean the location on disk where the maint plan is trying to access to write backups, logs, or delete files. Have you tried running the steps of the maint plan outside of an agent job?


Yup I have admin rights on the server and all drives and folders. I copied the sql script from the plan and executed on management studio and it worked fine
Is this 'XX\mrtrich99' your user or a service account? Does the displayed domain exist? Is that the domain that the computer is on? Double-check to make sure that the computer has not switched to WORKGROUP.


Thanks,

Jared
SQL Know-It-All

How to post data/code on a forum to get the best help - Jeff Moden
Post #1338812
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse