Improve company productivity with a Business Account.Sign Up

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

Restor back from SQL SERVER 2005 to SQL Server 2003

Hi Experts,

I have back from SQL server 2005 which i have to restore on SQL Server 2003.

Is it possible ???

If yes please help
0
santoshmotwani
Asked:
santoshmotwani
  • 4
  • 3
  • 2
2 Solutions
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
If you meant SQL Server 2003 as 2008, then its possible and just follow the regular steps for Restore.
If you meant SQL Server 2003 as 2000, then its not possible to restore your *.bak file from SQL Server 2005.
0
 
timexistCommented:
there is no sql server 2003. and I agree what rrjegan17  said.
0
 
santoshmotwaniAuthor Commented:
Sorry m confused.

I have sql running on windows server 2003
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
Raja Jegan RSQL Server DBA & ArchitectCommented:
ok..
What is the SQL Server version that is running on Windows Server 2003.
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
And steps to restore a backup via SSMS here:

http://msdn.microsoft.com/en-us/library/ms177429.aspx
0
 
santoshmotwaniAuthor Commented:
8.00.2039      SP4      Standard Edition
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
No, you can't restore backup taken from 2005 and restore it in SQL Server 2000.
If you want to copy that database to SQL Server 2000, then you have to use Database Publishing Wizard from here

http://www.microsoft.com/downloads/details.aspx?FamilyID=56e5b1c5-bf17-42e0-a410-371a838e570a&displaylang=en

to copy the data from SQL Server 2005 and run it in SQL Server 2000 on Windows Server 2003 machine.
0
 
timexistCommented:
http://www.sqlservercentral.com/Forums/Topic407783-146-1.aspx

you can run sql 2005 database in sql server 2000 mode
0
 
santoshmotwaniAuthor Commented:
Thanks Guys !!!
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.

  • 4
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now