SQL Server Performance

SQL Server 7.0 :- Maintenance plan hang

Discussion in 'General DBA Questions' started by rajeev_id, Jun 28, 2005.

  1. rajeev_id New Member

    Few days back my Maintenance plan was getting hang when it take#%92s backup for one database, so we removed that database from maintenance plan and that maintenance plan had started fine. But I am not able to use that database in any maintenance plan even I tried a separate maintenance plan for the same database.

    I have tried all dbcc command aginst that database but no error was found.

    If I restore the backup of same database then it work fine, I have checked on other server.


    Anyone know about such error?

    Rajeev Kumar Srivastava
    --ALWAYS BE POSITIVE!--
  2. deepakontheweb New Member


    What error Database Maintenance Plan shows?? and which backup maintenace plan takes when error come?

    Deepak Kumar

    --An eye for an eye and everyone shall be blind
  3. satya Moderator

    True, the error message gives more insight, check maint.plan log for information.
    Also try to backup the database using BACKUP statement from QA or schedule as a job and see the results.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  4. rajeev_id New Member

    I have tried the backup in QA and it do the backup properly,But while taking backup from maintenance it hangs and no error comes in maint history or job history.

    Rajeev Kumar Srivastava
    --ALWAYS BE POSITIVE!--
  5. satya Moderator

    Then try to trace it using PROFILER during this process.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  6. PeterJ New Member

    hi Rajeev

    Did you ever get this problem resolved ?

    I am having the same problem and I have no idea why or how to fix it?

Share This Page