Solved

Migrating database from SQL7 to SQL2005

Posted on 2008-10-10
2
187 Views
Last Modified: 2010-08-05
I just migrated a database from SQL7 to SQL2005. the database seems to have completed a successful migration how ever when I try to create a Database maintenance plan to backup the database it is not showing in the list. How can I fix this so that I can be able to create a backup maintenance plan.

Thanks
0
Comment
Question by:IGCNTech
2 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 250 total points
ID: 22693068
can you please check the database compatibility value for that database?
it might still be on value 70, so you might want to change to 90 (sql 2000)
0
 
LVL 51

Assisted Solution

by:Mark Wills
Mark Wills earned 250 total points
ID: 22693373
Compatability mode of 90 would be 2005   (sql 2000 is 80)

So, yes, check the compatability mode. Also make sure you have updated the serucrity matrix enabling the various "SQL" and "SQL Agent" profiles have been updated to access your database.

Might be worth doing a manual backup and restore to a "test" database (after changing compatability modes) and try a maintenance plan against that one...
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question