Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


DB Backup Maintenance Plan Won't Execute


DB Backup Maintenance Plan Won't Execute

Author
Message
mrtrich99
mrtrich99
Valued Member
Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)

Group: General Forum Members
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?
SQLRNNR
SQLRNNR
SSC-Insane
SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)

Group: General Forum Members
Points: 21113 Visits: 18259
What is the error message?



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


SQL RNNR

Posting Performance Based Questions - Gail Shaw

mrtrich99
mrtrich99
Valued Member
Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)

Group: General Forum Members
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.
SQLRNNR
SQLRNNR
SSC-Insane
SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)

Group: General Forum Members
Points: 21113 Visits: 18259
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, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw

mrtrich99
mrtrich99
Valued Member
Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)

Group: General Forum Members
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
SQLRNNR
SQLRNNR
SSC-Insane
SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)

Group: General Forum Members
Points: 21113 Visits: 18259
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, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw

mrtrich99
mrtrich99
Valued Member
Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)

Group: General Forum Members
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"
SQLRNNR
SQLRNNR
SSC-Insane
SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)

Group: General Forum Members
Points: 21113 Visits: 18259
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, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw

mrtrich99
mrtrich99
Valued Member
Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)

Group: General Forum Members
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
SQLKnowItAll
SQLKnowItAll
SSCrazy
SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)

Group: General Forum Members
Points: 2798 Visits: 3682
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search