patternsqlMinor
ALTER DATABASE... SET COMPATIBILITY_LEVEL -- will this impact log shipping? Can it be done live?
Viewed 0 times
thiscanimpactlogdatabasealterwilllivedoneshipping
Problem
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:
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?
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 = 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?
Solution
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.
Changing compatibility level does not impact logshipping, Mirroring or AlwaysON along with replication. I have done it safely during less activity time.
Context
StackExchange Database Administrators Q#218226, answer score: 2
Revisions (0)
No revisions yet.