changing compatability level of system databases

• Dhruva_51

  SSChampion

  Points: 10521

  More actions

  June 27, 2014 at 9:22 am

  #396973

  I have just upgraded a test server from sql server 2008 sp3 to sql server 2014 inplace upgrade. The compatability level of master database has not upgraded. It was showing 90 and the rest of system databases got updated to 120. Is it fine to update the compatibility level of master database ? Any precautions need to taken??

• Richie T

  SSC-Addicted

  Points: 478

  More actions

  July 11, 2014 at 4:33 am

  #1728670

  This should be fine, just need to take a backup in case you need to revert back to the old compatibility level.