• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 510
  • Last Modified:

RESTORE FROM SQL2008 TO SQL2005

Hi All,

I have problem to restore from SQL2008 to SQL2005.

what is the problem, any solution ?

Thank you.

0
emi_sastra
Asked:
emi_sastra
3 Solutions
 
cyberkiwiCommented:
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_derasariCommented:
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
 
ThakurVinayCommented:
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

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now