RESTORE FROM SQL2008 TO SQL2005

Hi All,

I have problem to restore from SQL2008 to SQL2005.

what is the problem, any solution ?

Thank you.

LVL 1
emi_sastraAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
cyberkiwiConnect With a Mentor Commented:
http://www.nwds-ak.com/WebResources/Database/RestoreSQLServer2008to2005/CreatingSQLScriptstoRestore2008.aspx

The additional features and data format in 2008 are not recognized by 2005, so it cannot restore a backup directly.
0
 
darshan_derasariConnect With a Mentor Commented:
You can not restore 2008 db to 2005.Please refer below link for more details:


http://social.msdn.microsoft.com/forums/en-US/sqldatabaseengine/thread/32a67469-0636-4ded-923f-2e257f7e68e1/

You can try another option explained in below link:

http://www.devx.com/dbzone/Article/40531

Hope this helps.
0
 
ThakurVinayConnect With a Mentor Commented:
You cannot down version restore. you can restore to the same version or above.

>> for this you can detach your mdf and ldf file and attach to lower version.
>> you can script the schema's and run the script to new server and bcp out the data
>> you may try import and export (i have not checked this one)
>>  use dts/ssis to transfer
>>check for third party tools

HTH
Vinay
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.