Solved

Restore MSSQL 2000 backup database to 2005

Posted on 2007-03-26
2
194 Views
Last Modified: 2010-03-19
I want to upgrade from MS SQL Server 2000 to 2005. I have the backup file of the current database in 2000. How can I restore (or other way) 2000 database to new 2005 database? I want to keep the tables, views, relationships, data, triggers, procedures, index... Is it possible to do that? Or any walkaround?
0
Comment
Question by:pupureg
[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 75

Accepted Solution

by:
Aneesh Retnakaran earned 125 total points
ID: 18794164
just restore the database as u normally did in SQL server 2000.
Once you have restored , change the Database Compatability level to 90 (in order to use the SQl server 2005 features )
0
 

Author Comment

by:pupureg
ID: 18807963
Yes it works. Thank you very much anneshattingal
0

Featured Post

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Problem with SqlConnection 4 193
SQL query with cast 38 64
How can i use WITH CTE for checking exist value? 3 64
Find unused columns in a table 12 93
I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

734 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