Microsoft, Enterprise Manager, SQL 2000--Database Backup using maintnance Plan not working

Posted on 2007-08-06
Last Modified: 2013-11-05
I am using Maintnance Plan to do nightly backups.  I have one database that for some reason the job shows that it's executing put it never finishes.  The database is full recovery mode.  At fist I had several databases in the maintnance plan, but then I saw that this one database was not completing, so I removed it and placed it in it's own maitnance plan.  It runs for days and never finishes.  However, when I do a backup from query analyzer, the back-up completes fine.  Any ideas?
Question by:yanci1179
    LVL 28

    Expert Comment

    What are the options you are selection when creating the maintenace plan for this database?
    LVL 28

    Accepted Solution

    The thing you can check is the size of your log files if it is huge take backup of this file manually and then shrink it.

    the second thing is you should Check the consistency of disk space allocation structures for a specified database.


    Author Comment

    the logs are not big; maitnance plan is still getting stuck when it gets to this database
    LVL 28

    Expert Comment

    Did you check the second option i mentioned?

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Suggested Solutions

    Title # Comments Views Activity
    sql find 2 classes on the same date 4 39
    drop all the tables in a database 5 41
    Stored Procedure error 45 35
    How to enforce inte 8 27
    by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
    In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now