We're currently running a server on Compatability mode 8 and I want to update it.
- What are the implications of just going in and changing it?
- What is likely to break?
- Is there anything that checks the data will survive before I perform it?
- Can I rollback to mode 8 without performing a restore and without loss of data?