Solved

Migrating database from SQL7 to SQL2005

Posted on 2008-10-10
2
192 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

617 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