Home Forums SQL Server 2005 Administering Maintenance Plan - Check Database Integrity Tool vs. Simple T-SQL Script RE: Maintenance Plan - Check Database Integrity Tool vs. Simple T-SQL Script

  • Sorry - I forgot to post the message. I sanatized the message replacing the DB name with MyDatabase and the Domain as MyDomain and the server as MyServer.

    The database is SQL 2005 Version 9.00.4035.00 and is hosted on a SQL cluster.

    --------------------------------------------------------------------------

    Thanks everybody. I appreciate the help

    --------------------------------------------------------------------------

    Date 8/31/2011 10:00:00 PM

    Log Job History (MyDatabase- DB Maintenance.Full Backup)

    Step ID 1

    Server MyServer

    Job Name MyDatabase- DB Maintenance.Full Backup

    Step Name Full Backup

    Duration 00:00:03

    Sql Severity 0

    Sql Message ID 0

    Operator Emailed

    Operator Net sent

    Operator Paged

    Retries Attempted 0

    Message

    Executed as user: MyDomain.COM\sqlclaSQLServerAgent. 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: 10:00:00 PM Progress: 2011-08-31 22:00:01.18 Source: {E034007A-D586-460E-9AF0-D6A69D8EBF54} Executing query "DECLARE @GUID UNIQUEIDENTIFIER EXECUTE msdb..sp".: 100% complete End Progress DTExec: The package execution returned DTSER_FAILURE (1). Started: 10:00:00 PM Finished: 10:00:01 PM Elapsed: 0.89 seconds. The package execution failed. The step failed.