Post reply

FULL backup db error

  • October 11, 2012 at 12:57 am

    #282997

    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.

  • October 12, 2012 at 6:35 am

    #1548594

    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

Viewing 2 posts - 1 through 1 (of 1 total)

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