March 5, 2015 at 3:24 am
I heard it is possible to restore the SQL 2014 db backup to lower version of sql server (2012,2008r2), can any one one sent me the syntax of restoring the backup?
March 5, 2015 at 3:41 am
ramyours2003 (3/5/2015)
I heard it is possible to restore the SQL 2014 db backup to lower version of sql server (2012,2008r2), can any one one sent me the syntax of restoring the backup?
Not as far as I know. Please post the link to your information source.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
March 5, 2015 at 3:47 am
Thanks for the reply , I know its not possible but if it is possible would like to know the procedure of restoring from higher to lower version .
March 5, 2015 at 3:50 am
Please tell us where you heard that it was possible.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
March 5, 2015 at 3:58 am
from one of my colleague he said by changing the compatibility mode while restoring the backup from sql 2014 to sql 2012
March 5, 2015 at 4:09 am
ramyours2003 (3/5/2015)
from one of my colleague he said by changing the compatibility mode while restoring the backup from sql 2014 to sql 2012
This will not work. Compatibility mode affects the features which are available, not the file structure.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
March 5, 2015 at 4:11 am
thanks for clarifying .
March 5, 2015 at 4:12 am
Just to add another voice to confirm - you cannot do this - going "forward" is sadly impossible.
What your friend was probably thinking of is that you can take an older version's backup and restore it to a newer version's server, but using Compatibility Mode you can make it "look like" the older version still.
March 6, 2015 at 2:56 am
ramyours2003 (3/5/2015)
I heard it is possible to restore the SQL 2014 db backup to lower version of sql server (2012,2008r2)
It's not possible. It's never been possible. Databases cannot be restored or attached down-version.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 6, 2015 at 2:57 am
ramyours2003 (3/5/2015)
from one of my colleague he said by changing the compatibility mode while restoring the backup from sql 2014 to sql 2012
Then he's either lying or he never actually tried it.
Compatibility level just affects how the query processor handles certain T-SQL constructs. Nothing else.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 6, 2015 at 11:04 am
ramyours2003 (3/5/2015)
Thanks for the reply , I know its not possible but if it is possible would like to know the procedure of restoring from higher to lower version .
The only way of doing this is to use BCP (as an example) to export the data from the higher version and to import it into the lower.
March 6, 2015 at 11:07 am
ramyours2003 (3/5/2015)
from one of my colleague he said by changing the compatibility mode while restoring the backup from sql 2014 to sql 2012
Your colleague is most definitely wrong. As has been recently explained to me, the compatibility level does not change the underlying RDBMS upon which the database is installed, it only makes some of the features available in previous versions to the database in that compatibility mode.
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply