I'm getting an error when trying to view the maintenance plan history!

  • Hello,

    I am using SQL Server 2008.

    =================================================

    Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64) Mar 29 2009 10:11:52 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.0 <X64> (Build 6002: Service Pack 2)

    ==================================================

    When I go to look at my maintenance plan history, I am getting an error message.

    =================================================

    TITLE: Microsoft.SqlServer.Management.Sdk.Sfc

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

    Failed to retrieve data for this request.

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

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

    ADDITIONAL INFORMATION:

    An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

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

    Lock request time out period exceeded. (Microsoft SQL Server, Error: 1222)

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.2531&EvtSrc=MSSQLServer&EvtID=1222&LinkId=20476

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

    BUTTONS:

    OK

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

    ================================================

    Has anyone seen this error message? If so, how is it resolved to be able to see the history?

    Thank you.

    Tony

    Things will work out.  Get back up, change some parameters and recode.

  • Hello,

    I was trying to figure out what was going on. I ran sp_who2. I noticed that a process was blocking another process. This was happening in MSDB.

    I clear the block and that resolved the issue. Now, I can see the maintenance plan history.

    Thanks everyone.

    Tony

    Things will work out.  Get back up, change some parameters and recode.

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

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