Compatibility Level of SQL Server Backups -


i'm running mssql 2014. i'm working on database compatibility level of 2008. backed working copy , sent off 1 of .net subs work on application extension. claims bak file has compatibility level of 2014. i'm skeptical. if he's right, there way can configure backup retain compatibility level of database , not adopt compatibility level of server?

these 2 different things. backup file can restored on same sql server version , (usually) 2 following versions. can't use backup file @ older instances.

database compatibility level limits functionalities can use within database data types, build in functions etc.


Comments

Popular posts from this blog

html - How can i make an element from a bottom stacking context stays in front of another higher stacking context? -

python - TypeError: start must be a integer -

html - href attribute breaking an element -