<div>
What are the options you are selection when creating the maintenace plan for this database?<br />

</div>


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


<div>
the logs are not big; maitnance plan is still getting stuck when it gets to this database
</div>


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

<div>
Did you check the second option i mentioned?
</div>


Did you check the second option i mentioned?

<div>
<div class="content wysiwyg-content">
I am using Maintnance Plan to do nightly backups. &nbsp;I have one database that for some reason the job shows that it's executing put it never finishes. &nbsp;The database is full recovery mode. &nbsp;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. &nbsp;It runs for days and never finishes. &nbsp;However, when I do a backup from query analyzer, the back-up completes fine. &nbsp;Any ideas?
</div>
</div>


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?

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

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.