Avatar of santoshmotwani
santoshmotwani
Flag for Australia asked on

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
Microsoft SQL Server 2005

Avatar of undefined
Last Comment
santoshmotwani

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Raja Jegan R

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
timexist

there is no sql server 2003. and I agree what rrjegan17  said.
santoshmotwani

ASKER
Sorry m confused.

I have sql running on windows server 2003
Raja Jegan R

ok..
What is the SQL Server version that is running on Windows Server 2003.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
Raja Jegan R

And steps to restore a backup via SSMS here:

http://msdn.microsoft.com/en-us/library/ms177429.aspx
santoshmotwani

ASKER
8.00.2039      SP4      Standard Edition
SOLUTION
Raja Jegan R

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
timexist

http://www.sqlservercentral.com/Forums/Topic407783-146-1.aspx

you can run sql 2005 database in sql server 2000 mode
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
santoshmotwani

ASKER
Thanks Guys !!!