Sql-server – change database compatibility level from 80 to 90 or higher with log shipping

compatibility-levellog-shippingsql serversql-server-2008-r2

I have a database on SQL 2008 R2 with compatibility level 80 and I want to change it to 90 or 100. I assumed that after changing, I may find a regression in our application's performance.

Many backups (like full, differential, and log) will be taken while using the new compatibility level 90 or 100. This database is also configured with log shipping.

My question is can I change compatibility level back to 80 safely without threats or must I take any considerations?

Best Answer

It's quite easy to change it back and forth. But you will have to test the performance. Here's a post on how to change it in SSMS.