June 4, 2010 at 7:00 am
we are running 2005 with SP3 shop.
Last 3 month my backup job (SSIS) package was running fine but today I got this error, i didn't change any setting.
Message
Executed as user: svcSQLAdm. Microsoft (R) SQL Server Execute Package Utility Version 9.00.4035.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 12:30:00 AM Progress: 2010-06-04 00:30:03.22 Source: {9E89287A-6C1C-46AF-91F9-DA1E5E17A243} Executing query "DECLARE @GUID UNIQUEIDENTIFIER EXECUTE msdb..sp".: 100% complete End Progress Progress: 2010-06-04 06:28:51.15 Source: Back Up Database Task Executing query "BACKUP DATABASE [databasename] TO DISK = N'\\de1clcr".: 100% complete End Progress DTExec: The package execution returned DTSER_FAILURE (1). Started: 12:30:00 AM Finished: 6:28:52 AM Elapsed: 21532 seconds. The package execution failed. The step failed.
please help me to solve this issue.
June 4, 2010 at 8:59 am
It's not obvious from that job step message what the problem is. Do you have any logging enabled in the package? If not, I suggest doing that and seeing what errors are logged for specific package tasks.
Greg
June 4, 2010 at 9:07 am
that the only message I have in log.
SQL Server Scheduled Job 'Database Full Backup.Subplan_1' (0xBDCFF8C5B2FAFA408DA0E59818DCEFCE) - Status: Failed - Invoked on: 2010-06-04 00:30:00 - Message: The job failed. The Job was invoked by Schedule 117 (Database Full Backup.Subplan_1). The last step to run was step 1 (Subplan_1).
June 4, 2010 at 10:14 am
take a manual backup and see if it gives any more info than the package. Also what SP are you running?
June 4, 2010 at 10:18 am
I can't take a backup now, it is a production db, I have to run during night time.
last three month my job was working fine, but last night i got this error
I have SP3 install.
June 4, 2010 at 11:35 pm
Delete the job and recreate it and it should work.
To troubleshoot the issue I will check the user privelage under which the job runs just to be sure the user has proper rights. Does the job have params?
MCTS: BI 2008, MCITP: BI 2008
Stay Thirsty My Friends
June 5, 2010 at 1:05 am
Check the Windows event log to see if there are any backup error messages. Is this a custom built SSIS package or a maintenance package created in SSMS? I've seen where just opening up the backup task, reviewing the databases being backed up and re-saving the package has resolved issues before... especially if a database has been dropped.
If custom SSIS package, I concur with Greg in that you should add logging either by manually building a log table or using the built in logging. If this was built via SSMS, you can right click on the package in SSMS and review history to possibly see more information.
David
December 6, 2010 at 7:12 am
I was getting this error all of a sudden on a maintenance plan that was set to backup all user databases. The plan had been running fine for months. After I got this error I dug around and noticed that for some reason the plan was changed to backup specific databases instead of all user databases. However no specific databases were set to be backed up. I changed it back to backup all user databases and it ran fine after that.
January 16, 2017 at 9:00 am
What is wrong with the website?
Did someone push a new release?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 16, 2017 at 9:02 am
I get the following error in the output file on a Backup Job:
Microsoft (R) SQL Server Execute Package Utility
Version 11.0.6020.0 for 64-bit
Copyright (C) Microsoft Corporation. All rights reserved.
Started: 1:00:00 PM
DTExec: The package execution returned DTSER_FAILURE (1).
Started: 1:00:00 PM
Finished: 2:27:25 PM
Elapsed: 5245.2 seconds
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply