April 24, 2007 at 9:09 am
I am gettnig following error when performing a backup using a maintenance plan:
Date 4/24/2007 11:01:23 AM
Log Job History (MaintenancePlan1.Subplan_1)
Step ID 1
Server 006-DEVSQL2005
Job Name MaintenancePlan1.Subplan_1
Step Name Subplan_1
Duration 00:00:09
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0
Message
Executed as user: tcs\svcDBASQLAdmin. Microsoft (R) SQL Server Execute Package Utility Version 9.00.3042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 11:01:24 AM. The return value was unknown. The process exit code was -1073741819. The step failed.
I am able to use the transact sql generated by the maint plan and create a backup. is this a 64 bit issue?
April 25, 2007 at 9:06 am
I am successfully(now) performing backup routines on our SQL 2005 9.0.3050 release x64 machines.... I have the owner of the plans being a sqlservice account with the permissions to run the backups. What I also had to do was change the owner of the job to the sqlservice account also to get it to work correctly, even though my login is full admin. The release you are at does have date issues with maintenace plans and you may want to update to KB933508 to see if that helps
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply