Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 201
  • Last Modified:

Migrating database from SQL7 to SQL2005

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
IGCNTech
Asked:
IGCNTech
2 Solutions
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
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
 
Mark WillsTopic AdvisorCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now