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 |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2011-11-15 : 07:57:09
|
| Hi Team,I've a DB in 2008 R2 environment. i need to restore the DB in 2005 environment. i know it is not possible practically, but just asking is there any chance to do that?if i change the compatiability to 90, and then take the backup, will be restorable in sql 2005?please adviceArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-11-15 : 08:04:00
|
| No. But you can install sql server express and restore to that probably.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-11-15 : 09:29:52
|
| No. Absolutely no chance at all, no matter what the compatibility is set to. Compat mode only affects what syntax the query processor accepts as valid. Script objects. Export data. Recreate on SQL 2005.--Gail ShawSQL Server MVP |
|
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2011-11-15 : 10:01:10
|
| Yes, You can never restore SQL Server 2008 backup on SQL Server 2005 or 2000, even you cann't restore SQL Server 2008 R2 backup on SQL Server 2008 . Only way to restore is that you have to create script for Schema and Data and then you can run this on SQL Server 2005.--------------------------http://connectsql.com/ |
|
|
|
kiran_chava
Starting Member
1 Post |
Posted - 2011-11-16 : 06:20:09
|
| Hi, yes,we have restore 2008 R2 database in 2000, but there will be one condition that is when ever the database created in 2008 R2 the compatability is set to 80 and then created the database.That database will be restore in 2000.kiran kumar ch |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-11-16 : 09:31:24
|
quote:
Originally posted by kiran_chava
yes,we have restore 2008 R2 database in 2000, but there will be one condition that is when ever the database created in 2008 R2 the compatability is set to 80 and then created the database.That database will be restore in 2000.
No it will not. A SQL 2008 database cannot be restored to SQL 2005 or SQL 2000 ever under any circumstances. The compatibility level has nothing whatsoever to do with the database version. The database version matches the version of the instance that the database is attached to. A database attached to a SQL 2008 instance is a SQL 2008 database.The compatibility level is solely used by the query processor to determine what T-SQL constructs are valid and how some statements are to be processed. It does not in any way affect the structure of the database file (I have a database with a compatibility level of 90 (2005) that's using compression (a feature introduced in SQL 2008))It is the structure of the database file and the internal database version that affect what versions the database can be attached to, and the rule is very simple - upgrade yes, downgrade never.--Gail ShawSQL Server MVP |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2011-11-17 : 01:41:23
|
| If you need to move a database from 2008 to an earlier version: Script out all objects - recreate on earlier version - an transfer dataJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
|
|
backup restore from 2008 to 2005