Sql-server – ALTER DATABASE… SET COMPATIBILITY_LEVEL — will this impact log shipping? Can it be done live

sql server

SQL Server 2017 Standard Ed

I have a database that is at level 2008.

I want to bring it up to current.

This database log ships.

Is it safe to run:

ALTER DATABASE database_name   
SET COMPATIBILITY_LEVEL = <whatever>

1- Live , when the app is running (I know the app is compatible with the new level)

2- Will this break or mess with log shipping?

Best Answer

You can do it in off hours or when you have less activity on the server. Doing when the server is busy, will incur blocking.

Changing compatibility level does not impact logshipping, Mirroring or AlwaysON along with replication. I have done it safely during less activity time.

Related Question