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?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Raja Jegan RConnect With a Mentor SQL 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
Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

 
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 RConnect With a Mentor SQL 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
All Courses

From novice to tech pro — start learning today.