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
Post a Comment