SQL 2005 database back using litespeed. - job fail

• kshatriya24

  SSC Eights!

  Points: 887

  More actions

  August 29, 2011 at 7:43 am

  #256470

  I'm getting following message while trying to run database back up job.

  Date8/28/2011 4:00:00 AM

  LogJob History (PMDB Database Backup Maintenance Plan.Litespeed PMDB Complete Database Backup)

  Step ID1

  ServerTESTSEVER

  Job NamePMDB Database Backup Maintenance Plan.Litespeed PDBM Complete Database Backup

  Step NameLitespeed PMDB Complete Database Backup

  Duration00:15:16

  Sql Severity0

  Sql Message ID0

  Operator Emailed

  Operator Net sent

  Operator Paged

  Retries Attempted0

  Message

  Executed as user: testserver\Admin. ...n 9.00.4035.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 4:00:00 AM Progress: 2011-08-28 04:00:01.48 Executing query "DECLARE @GUID UNIQUEIDENTIFIER EXECUTE msdb..sp_ma".: 100% complete End Progress Error: 2011-08-28 04:15:14.62 Code: 0xC002F210 Source: Litespeed PMDB Complete Backup Execute SQL Task Description: Executing the query "execute master..xp_slssqlmaint N'-D "PMDB" -VrfyBackup -BkUpMedia DISK -DelBkUps 7DAYS -BkUpDB "\\TE02\sql\TESERVER\PMDB\COMPLETE" -BkExt "bak" -Exclude Deleted Offline LogShippng -NOOPTOLR -CompressionLevel 3 -Logging 0 -Default "%D_%T_%Y-%m-%d-%H%M%S.%EXT%" -LogEngine 0 -RunId "7020FF37-56DD-44CA-B2C1-DF82BCDEC0BD" "Litespeed PMDB Complete Backup (TESTSERVER)" -NO_OUTPUT '" failed with the following error: " Msg 61700, Level 16, State 1, Line 1179648: A timeout... The package execution fa... The step failed.

• Joie Andrew

  One Orange Chip

  Points: 27360

  More actions

  August 29, 2011 at 3:10 pm

  #1374749

  What does the maintenance plan history say? It should show the specific step the job failed on with more detailed error information.

  Joie Andrew
  "Since 1982"