We are using a production database (SQL Server 2012) and database compatibility mode is 90 (SQL Server 2005).
- Can I alter the database to single user mode and change to 110?
- What will be the impact if run
Alter database <DBNAME> SET SINGLE_USER with rollback immediate
- After changing the compatibility level and switching to multi user will Log shipping work?