SQL Server Performance

Maintenance plan issue

Discussion in 'SQL Server 2005 General DBA Questions' started by Gamexane, Mar 21, 2011.

  1. Gamexane New Member

    Dear all,
    i'm trying to do a bkp in SQL 2005 of databases migrated from SQL 7.0 but when i go to select the databases, only appears the databases created in SQL 2005 and not the databases created in SQL 7.0. Someone know why this databases doesn't appears ?
    I'm novato with SQL.
    Could you help me please ?
    Thanks in advance.
    Gamexane, Mar 21, 2011
    #2

  2. Luis Martin Moderator

    Welcome to the forums!
    "only appears the databases created in SQL 2005 and not the databases created in SQL 7.0"
    What are you using to do a backup?.
    When you said "..and not the databases created in 7.0" you mean: created in 7 and migrated to 2005?
    Luis Martin, Mar 21, 2011
    #3

  3. satya Moderator

    Welcome to the forums.
    Can you check the database compatibility mode from SQL SErver Management Studio --> Expand databases folder --> right click on that SQL70 database and go to options to see the RECOVERY model.
    satya, Mar 22, 2011
    #4

Share This Page