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

python - TypeError: start must be a integer -

c# - DevExpress RepositoryItemComboBox BackColor property ignored -

django - Creating multiple model instances in DRF3 -