Databases with simple recovery will be excluded (SQL Server 2008) RRS feed

  • Question

  • Hi,

    Question of a beginner: I'm trying to use the SQL Server Maintenance Plan Wizard. After the page "Define Back Up Database (Full) Task", there is a box with the warning : "Databases with simple recovery will be excluded".

    What does that mean?

    Thanks for your help.

    Sunday, February 6, 2011 2:20 PM


All replies

  • Hi,

    It looks like at first setp you have selected LOG backup (Backup Database(Transaction LOG)) not full backup.

    If this is not the case kindly revert.

    -Chintak (My Blog)

    Sunday, February 6, 2011 2:46 PM
  • Hi,

    In fact, I selected both. Know I think that this warning appeared with the second box: Define Backup Database (Transaction LOG) Task.


    Sunday, February 6, 2011 3:14 PM
  • If Database Recevory Model is set to simple you cannot take Transactiona Log Backups. If you want to take full backups and transactional log backups change recovery model to bulk logged or full
    With kind regards
    Krystian Zieja
    Follow me on twitter
    My Blog
    • Marked as answer by WLID1966 Sunday, February 6, 2011 4:25 PM
    Sunday, February 6, 2011 4:21 PM