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 |
|
asm
Posting Yak Master
140 Posts |
 Posted - 2009-08-23 : 08:45:03
|
| How to restore sql 2008 backup into sql 2005 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-08-23 : 09:34:57
|
| can't.you can script out the objects and recreate in 2005, then transfer the data over using bcp/bulk insert or ssis |
 |
|
|
asm
Posting Yak Master
140 Posts |
Posted - 2009-08-24 : 21:28:47
|
| i tried import / export wizard but due to identity column in table... it generate error...pls suggest how to achive the result. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-08-24 : 21:43:50
|
| Enable Identity insert in Export/Import Wizard. |
|
|
|
|
|
|
resotre backup