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 |
|
vaibhavktiwari83
Aged Yak Warrior
843 Posts |
 Posted - 2010-02-19 : 08:21:56
|
| Hi every one, i need to restore the database backup of sql 2008 over sql 2005.What can i do as its not possible directly. is there any option while taking bacup or any other way.please help me..Vabhav T |
|
|
DaleTurley
Yak Posting Veteran
76 Posts |
Posted - 2010-02-19 : 08:26:39
|
| There is no way of going backwards as far as i'm aware.Try scripting the database in 2008, recreating on 2005 and then importing the data in each table through either linked servers or export import using bcp... |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2010-02-19 : 08:28:23
|
| Use Generate Script tasks in SQL 2008 Which can scripts DDL and DML both. |
|
|
|
vaibhavktiwari83
Aged Yak Warrior
843 Posts |
Posted - 2010-02-19 : 08:33:14
|
| hi sodeep,thanks for replyyou mean instead of taking backup i should generate script of schema along with data.then execute it on 2005.but will it work script of 2008.thanks daleturley but that is very lenghy and hactic too.Vabhav T |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-02-19 : 09:14:52
|
| It's the only way. You cannot restore a 2008 backup on SQL 2005 nor can you detach a SQL 2008 DB and attach to SQL 2005. The script will work provided you haven't used SQL 2008 features in the DB.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
compatibility of sql server 2005 and 2008