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.
  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?
  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.

Share This Page