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
LVL 16
santoshmotwaniAsked:
Who is Participating?
 
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
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
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

 
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
ok..
What is the SQL Server version that is running on Windows Server 2003.
0
 
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
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 & Architect, EE Solution GuideCommented:
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.

All Courses

From novice to tech pro — start learning today.