my backup was running fine, but today I got error Executing query "BACKUP DATABASE [crs5_oltp] TO DISK = N'\\de1clcr".: 100% complete End Progress DTExec: The package execution returned DTSER_FAILURE (1).

Question

my backup was running fine, but today I got error Executing query "BACKUP DATABASE [crs5_oltp] TO DISK = N'\\de1clcr".: 100% complete End Progress DTExec: The package execution returned DTSER_FAILURE (1).

MAK-1128556

SSCarpal Tunnel

Points: 4594
More actions
December 4, 2009 at 6:02 am

#139763

I am in 2005 shop and running the backup through Maintenance plans but tonight I got this error
Executing query "BACKUP DATABASE [crs5_oltp] TO DISK = N'\\de1clcr".: 100% complete End Progress DTExec: The package execution returned DTSER_FAILURE (1).

Viewing 15 posts - 1 through 15 (of 19 total)

You must be logged in to reply to this topic. Login to reply

muthukkumaran Kaliyamoorthy SSCoach Points: 19026 More actions · Answer 1

MAK-1128556 (12/4/2009)
I am in 2005 shop and running the backup through Maintenance plans but tonight I got this error
Executing query "BACKUP DATABASE [crs5_oltp] TO DISK = N'\\de1clcr".: 100% complete End Progress DTExec: The package execution returned DTSER_FAILURE (1).

Hi,

For more detail check the sql server errorlog & OS

Also Under the management--> Right click the maintenance plan -->View history

http://social.msdn.microsoft.com/Forums/en/sqldisasterrecovery/thread/0eca38cf-fa4a-4d8f-99fc-f642d8652d6c%5B/url%5D

Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/

MAK-1128556 SSCarpal Tunnel Points: 4594 More actions · Answer 2

An exception occurred while executing a Transact-SQL statement or batch.

muthukkumaran Kaliyamoorthy SSCoach Points: 19026 More actions · Answer 3

MAK-1128556 (12/4/2009)
An exception occurred while executing a Transact-SQL statement or batch.

MAK

Post the result

select @@version

Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/

muthukkumaran Kaliyamoorthy SSCoach Points: 19026 More actions · Answer 4

Check the MS link

http://support.microsoft.com/kb/914779

Edit:Post the correct link

Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/

MAK-1128556 SSCarpal Tunnel Points: 4594 More actions · Answer 5

my job was working before, but today I got an error

MAK-1128556 SSCarpal Tunnel Points: 4594 More actions · Answer 6

Thanks Muthukkumaran,

what can I do now, link didn't give me any information

muthukkumaran Kaliyamoorthy SSCoach Points: 19026 More actions · Answer 7

Hi,

Check the job owner and try to run the job manually.

Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/

MAK-1128556 SSCarpal Tunnel Points: 4594 More actions · Answer 8

My job was working fine with svcAdm account, but today I got the error with same account

Xxx Right there with Babe Points: 738 More actions · Answer 9

Have you tried recreating the plan? If it's a simple maintenance plan backup, recreating will only take a few minutes. If you have, do you get the same error?

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 10

Unfortunately, we can't see what you see and you aren't giving us enough information to really help. Please provide the FULL error message(s) you have received.

muthukkumaran Kaliyamoorthy SSCoach Points: 19026 More actions · Answer 11

Lynn Pettis (12/4/2009)
Unfortunately, we can't see what you see and you aren't giving us enough information to really help. Please provide the FULL error message(s) you have received.
S,I agree with Lynn

Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/

MAK-1128556 SSCarpal Tunnel Points: 4594 More actions · Answer 12

my new job work fine.

this particulare job give us a error, there is any way we find out the cause of this error

MAK-1128556 SSCarpal Tunnel Points: 4594 More actions · Answer 13

see the error message

Message

Executed as user: PCA\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: 1:49:28 AM Progress: 2009-12-04 01:49:31.63 Source: {E0B03A3D-1533-406E-9885-70B44C0D693D} Executing query "DECLARE @GUID UNIQUEIDENTIFIER EXECUTE msdb..sp".: 100% complete End Progress Progress: 2009-12-04 01:49:31.80 Source: Maintenance Cleanup Task Executing query "EXECUTE master.dbo.xp_delete_file 0,N'\\de1clcrsql".: 100% complete End Progress Progress: 2009-12-04 06:39:05.02 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: 1:49:28 AM Finished: 6:39:06 AM Elapsed: 17378.3 seconds. The package execution failed. The step failed.

MAK-1128556 SSCarpal Tunnel Points: 4594 More actions · Answer 14

see the error message

Message

Executed as user: PCA\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: 1:49:28 AM Progress: 2009-12-04 01:49:31.63 Source: {E0B03A3D-1533-406E-9885-70B44C0D693D} Executing query "DECLARE @GUID UNIQUEIDENTIFIER EXECUTE msdb..sp".: 100% complete End Progress Progress: 2009-12-04 01:49:31.80 Source: Maintenance Cleanup Task Executing query "EXECUTE master.dbo.xp_delete_file 0,N'\\de1clcrsql".: 100% complete End Progress Progress: 2009-12-04 06:39:05.02 Source: Back Up Database Task Executing query "BACKUP DATABASE [database name] TO DISK = N'\\de1clcr".: 100% complete End Progress DTExec: The package execution returned DTSER_FAILURE (1). Started: 1:49:28 AM Finished: 6:39:06 AM Elapsed: 17378.3 seconds. The package execution failed. The step failed.