Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I created a database using a november CTP preview of MS SQL Server 2008R2. Is it possible to transfer this database to use with older version, SQL Server 2008?

share|improve this question
    
Have you tried backing it up on the R2 SQL and restoring on the 2008? Should work. I know 2008 to 2005 doesn't so maybe this is the same. –  Campo May 1 '10 at 22:13
    
No, restoring didn't work. server 2008 showed message that his version is older then the version of server created backup –  flashnik May 2 '10 at 6:31

2 Answers 2

up vote 1 down vote accepted

No, you can never downgrade by backup/restore or detach/attach

Your best bet is to use the wizard or an SSIS package

From Paul Randall's myth series, item 24h

share|improve this answer
    
I managed to do it whrough import.export wizard and specifying instances using tcp:ip/instanceName syntax. –  flashnik May 3 '10 at 7:46

If backup/restore doesn't work, here's a couple of other ideas:

  • BCP the data
  • use replication to copy the data to a 2008 instance
  • if the dataset isn't ridiculously large, write a script to do it
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.