Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Delila
Starting Member
11 Posts |
 Posted - 2011-10-26 : 03:17:34
|
| Hello,I have a backup made from an Sql server 2008 R2, it seems to be impossible to retore it on Sql server 2008.My question is what is the best practice to downgrade a database from Sql server 2008 R2 to sql server 2008.Regards, |
|
|
chris_cs
Posting Yak Master
223 Posts |
Posted - 2011-10-26 : 07:01:40
|
| You cannot directly 'downgrade' a database from R2 to 2008.The best thing to do would be to either create a database on the earlier version and push the data across using a DTS package, or try using the copy database wizard.I think you can use the copy database wizard from R2 to 2008 but someone more knowledgable might correct me on this.Hope this helps.----------------------------Junior DBA learning the ropes |
 |
|
|
Cindyaz
Yak Posting Veteran
73 Posts |
Posted - 2011-10-26 : 09:18:32
|
| The other option is to BCP out data to text files on source machine, move the files to destination and import it there using bcp in or bulk import. |
|
|
|
Delila
Starting Member
11 Posts |
Posted - 2011-10-26 : 12:38:06
|
| Thanks chris cs i will try your solution@Cindyaz please could you be more clear, and what is BCP ? |
|
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2011-10-26 : 14:18:14
|
| Can I ask why you need to downgrade? Best practice would be to identify the issues and correct them instead of downgrading.However, I do understand there are circumstances that require that you downgrade.Jeff |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-10-26 : 15:08:28
|
quote:
Originally posted by jeffw8713
Can I ask why you need to downgrade? Best practice would be to identify the issues and correct them instead of downgrading.However, I do understand there are circumstances that require that you downgrade.Jeff
Cause the OP has a backup of a higher version and cannot restore it on a lower version.PBUH |
|
|
|
|
|
|
DownGrade from R2