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

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?
yanci1179Asked:
Who is Participating?
 
imran_fastCommented:
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.
using DBCC CHECKALLOC


0
 
imran_fastCommented:
What are the options you are selection when creating the maintenace plan for this database?
0
 
yanci1179Author Commented:
the logs are not big; maitnance plan is still getting stuck when it gets to this database
0
 
imran_fastCommented:
Did you check the second option i mentioned?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.