Post reply

Some database missing from maintenance plan

  • December 16, 2009 at 8:39 am

    #136009

    I have Ent. Ed. SQL 2005 SP2. I am trying to create a maintenance plan to backup some of my Databases (User Created). However when I use the create maintenance plan wizard in the database list some of my database are missing. Why some of the database are missing from the list.

    Thanks

    R

  • December 16, 2009 at 10:48 pm

    #1093411

    Are you trying to create maintenance plan to backup transaction log and are these databases in simple recovery model?

  • December 16, 2009 at 11:36 pm

    #1093414

    Also, databases in restoring state (log shipping/mirroring?) are displayed...

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply