Solved

Migrating database from SQL7 to SQL2005

Posted on 2008-10-10
2
184 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 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 250 total points
Comment Utility
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
Comment Utility
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

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This video discusses moving either the default database or any database to a new volume.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

728 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now