.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Home >> Forum >> Sql Server >> Post New QuestionBookmark and Share Subscribe to Forum

Is it possible to restore SQL Server 7 Back up in SQL server 2008 or 2005?

Posted By: Sajid P K     Posted Date: October 14, 2010    Points:2   Category :Sql Server

IS there any way to restore SQL Server 7 Back up in SQL server 2008 or 2005?

Sajid P K

Author: Ramesh P             
Posted Date: October 20, 2010     Points: 5   

Yes. It is possible. Use the following steps,

Step 1 : Full backup of source database
Step 2 : Move the full backup to destination server2005
step 3 : Restore the fullbackup in sql server and change the compatibility level from 80 to 90
Solution 2 : Detach and Attach Method
Solution 3 : Copy Database Wizard



Author: Sajid P K             
Posted Date: October 21, 2010     Points: 5   


Here Db is SQL Server 7 , not 2000.

Post Reply

You must Sign In To post reply
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more Here
Quick Links For Forum Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  OOPs  SilverlightIISJQuery

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend