Not all databases available for maintenance plan

[dgillz]

SQL Server 2005. In SQL server mgmnt studio I tried to change a maintenance plan to add an additional user database to the backup. However not all the databases are listed and I cannot add the database I want to the plan.

Any ideas why the database would not be available?

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[dgillz]

I hate to beg but anyone have ideas on this?

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[SQLWilts]

Looking at the database in management studio, is it off line or restoring?

Is the plan you are trying to add the DB to a log file backup? If it is, check that the DB you are trying to backup is in full recovery mode.

right click on the database and choose properties. then the options node