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

FULL backup db error Expand / Collapse
Author
Message
Posted Thursday, October 11, 2012 12:57 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, June 14, 2013 12:05 PM
Points: 352, Visits: 1,697
Hi we are using Litespeed for backups. We got below error for full user db backup maintenance job. is this something network error.
and also after job failure I noticed that Litespeed maintaince plan - in design tab- backup task disappered. is some one edited/deleted this? anyone encountered this issue?
thanks.


Executed as user: test\testsqlservice. Microsoft (R) SQL Server Execute Package Utility Version 10.0.5500.0 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 5:49:32 PM Progress: 2012-10-10 17:49:37.00 Source: {xxxxxx-175xxx7-4xxx9BF-xxxx-xxxxxxxx} Executing query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp_ma...".: 100% complete End Progress Progress: 2012-10-10 17:49:49.41 Source: Full appdb backup Executing query "BACKUP DATABASE [LiteSpeedLocal] TO DISK = N'T:\B...".: 50% complete End Progress Progress: 2012-10-10 17:49:49.89 Source: Full appdb backup Executing query "declare @backupSetId as int select @backupSetId =...".: 100% complete End Progress Progress: 2012-10-10 18:47:04.23 Source: Full appdb backup Executing query "BACKUP DATABASE [DB] TO DISK = N'T:\Backup\...".: 50% complete End Progress Progress: 2012-10-10 19:11:14.28 Source: Notify Operator 1 Executing query "EXECUTE msdb.dbo.sp_notify_operator @name=N'DBANOT...".: 100% complete End Progress DTExec: The package execution returned DTSER_FAILURE (1). Started: 5:49:32 PM Finished: 7:11:17 PM Elapsed: 4841.67 seconds. The package execution failed. The step failed.
Post #1371233
Posted Friday, October 12, 2012 6:35 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 7:57 AM
Points: 415, Visits: 1,689
nihal9200_kwada (10/11/2012)
Hi we are using Litespeed for backups. We got below error for full user db backup maintenance job. is this something network error.
and also after job failure I noticed that Litespeed maintaince plan - in design tab- backup task disappered. is some one edited/deleted this? anyone encountered this issue?
thanks.


Executed as user: test\testsqlservice. Microsoft (R) SQL Server Execute Package Utility Version 10.0.5500.0 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 5:49:32 PM Progress: 2012-10-10 17:49:37.00 Source: {xxxxxx-175xxx7-4xxx9BF-xxxx-xxxxxxxx} Executing query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp_ma...".: 100% complete End Progress Progress: 2012-10-10 17:49:49.41 Source: Full appdb backup Executing query "BACKUP DATABASE [LiteSpeedLocal] TO DISK = N'T:\B...".: 50% complete End Progress Progress: 2012-10-10 17:49:49.89 Source: Full appdb backup Executing query "declare @backupSetId as int select @backupSetId =...".: 100% complete End Progress Progress: 2012-10-10 18:47:04.23 Source: Full appdb backup Executing query "BACKUP DATABASE [DB] TO DISK = N'T:\Backup\...".: 50% complete End Progress Progress: 2012-10-10 19:11:14.28 Source: Notify Operator 1 Executing query "EXECUTE msdb.dbo.sp_notify_operator @name=N'DBANOT...".: 100% complete End Progress DTExec: The package execution returned DTSER_FAILURE (1). Started: 5:49:32 PM Finished: 7:11:17 PM Elapsed: 4841.67 seconds. The package execution failed. The step failed.



It has been quite sometime for me to have used Litespeed. but the above logs look like to have been picked from SQL Server. By default a job history does not capture all the logs especially when it is huge. Do 1 thing, go to properties of the job step and in the advanced tab, check on the option which logs complete step output. You may also opt for an option of having the output written to a text file. May be from there we can move forward. We need some clue.

Thanks
Chandan
Post #1372074
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse