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 |
|
adrbrusc
Starting Member
3 Posts |
 Posted - 2010-01-14 : 07:55:14
|
| Hi,Is it possible to restore a backup file created in SQL 2008 to SQL 2005. I'm trying but it is not worked.Thanks |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2010-01-14 : 08:00:39
|
| Not through the normal backup \ restore. You'll have to look at creating the object scripts from 2008 - but in 2005 modeJack Vamvas--------------------http://www.ITjobfeed.com |
 |
|
|
adrbrusc
Starting Member
3 Posts |
Posted - 2010-01-14 : 08:09:00
|
| Thanks jackv...I don't use SQL server very often so I dont understant very well how can I do this. Are there some tutorial explain this process? I really need to restore this SQL 2008 Database to SQL 2005.Thanks a lot! |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-01-14 : 08:38:56
|
In outline the steps would be:1) Generate a script (on SQL 2008 database) for all the database objects (tables, Columns, Constraints ... etc.), using SQL 2005 compatible mode2) Create an empty database on SQL 2005 and run the script3) Use the Data Transfer tools to push the data across from SQL 2008 into the newly created database / tables in SQL 2005.If you JUST want the data in SQL 2005, and don't care about Stored Procedures, Foreign keys, indexes, etc. then this route might do:1) Create empty database in SQL 20052a) Use data transfer tools to transfer the data. These will automatically create the tables (and a Primary Key, but no other indexes etc.)or 2b) on the SQL 2005 database/server create a Linked Server to the SQL2008 server and do:SELECT * INTO dbo.MyTable FROM My2008Server.SQL2008DatabaseName.dbo.MyTablerepeat for each table you want to transfer. The table will be created automatically, but it won't have any Indexes etc.If you need detailed instructions just indicate which route suits you best and some kind person here will point you in the right direction, I'm sure  |
|
|
|
adrbrusc
Starting Member
3 Posts |
Posted - 2010-01-14 : 14:18:04
|
| Ok, it works very well! Thanks a lot !!! |
|
|
|
|
|
|
|
|
Restore data from SQL 2008 to SQL 2005