Post reply

SQL job failed

  • June 27, 2012 at 7:16 pm

    #276976

    Hi,

    SQL diff backup job failed. below are the errors.Please advise. Thanks!

    Maintanance plan history:

    Executed as user: domain\sqlservice01. Microsoft (R) SQL Server Execute Package Utility Version 10.0.4000.0 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 8:00:00 PM Progress: 2012-06-27 20:00:04.48 Source: {BC9ADD5F-9C0C-45C2-850E-551EE535B89E} Executing query "DECLARE @GUID UNIQUEIDENTIFIER EXECUTE msdb..sp...".: 100% complete End Progress Error: 2012-06-27 20:00:25.11 Code: 0xC002F210 Source: Back Up Database 1 Execute SQL Task Description: Executing the query "execute master..xp_slssqlmaint N'-D "ALL DATABASES..." failed with the following error: "Msg 0, Level 0, State 0, Line 0: [Microsoft][ODBC Driver Manager] Connection not open Msg 0, Level 0, State 0, Line 0: [Microsoft][ODBC Driver Manager] Connection not open Msg 0, Level 0, State 0, Line 0: [Microsoft][ODBC Driver Manager] Connection not open Msg 0, Level 0, State 0, Line 0: [Microsoft][ODBC Driver Manager] Connection not open Msg 0, Level 0, State 0, Line 0: [Microsoft][ODBC Driver Manager] Connection not open Msg 0, Level 0, State 0, Line 0: [Microsoft][ODBC Driver Manager] Connection not open Msg 0, Level 0, State 0, Line 0: [Microsoft][ODBC Driver Manager] Connection not open ". End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 8:00:00 PM Finished: 8:00:54 PM Elapsed: 54.5 seconds. The package execution failed. The step failed.

  • June 27, 2012 at 8:20 pm

    #1506432

    Resolved. looks like intermittent.

    reran the job and job ran successfully

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

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