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

  • DoubleEx (9/2/2011)


    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.

    This is the job history from the agent - not the maintenance plan history. To get the maintenance plan history you need to right click on the maintenance plan in Object Explorer and select View History.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs