March 4, 2015 at 1:19 pm
If I have a SQL Server 2014 database is there any way I can back it up and restore the backup to 2008? Does setting compatibility mode to 2008 allow this? I think I know the answer, but I want to verify.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
March 4, 2015 at 1:29 pm
NO. compatibility level controls the features not database internals.
March 4, 2015 at 1:33 pm
Yeah, that's what I thought. I figured I should ask to be absolutely sure.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
March 4, 2015 at 1:35 pm
No. You can't.
There is only way You migrate data
On top of that even if You create schema DB on 2008.
You need to make sure when create schema for DB from SQL 2012
You need to consider about Column store index, Non column store index ,Memory optimize Table etc
March 6, 2015 at 12:31 pm
Not using traditional backup and restore methodology but it could work with BCP.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply