Solved

RESTORE FROM SQL2008 TO SQL2005

Posted on 2010-08-24
3
503 Views
Last Modified: 2012-05-10
Hi All,

I have problem to restore from SQL2008 to SQL2005.

what is the problem, any solution ?

Thank you.

0
Comment
Question by:emi_sastra
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 58

Accepted Solution

by:
cyberkiwi earned 200 total points
ID: 33517977
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
 
LVL 5

Assisted Solution

by:darshan_derasari
darshan_derasari earned 200 total points
ID: 33518137
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
 
LVL 5

Assisted Solution

by:ThakurVinay
ThakurVinay earned 100 total points
ID: 33518651
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

Business Impact of IT Communications

What are the business impacts of how well businesses communicate during an IT incident? Targeting, speed, and transparency all matter. Find out more in this infographic.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question