0

I’m relatively new to SQL Server and my company is currently using an older version (2014) of the Ola Hallengren Maintenance Solution. We’re looking to upgrade to a version that supports SQL Server 2022.

Has anyone here had experience with this type of upgrade? Are there specific considerations or potential issues to watch out for during the upgrade process? Or can we just replace the old version with the new one and then create new jobs etc?

Any advice or insights would really help, thankyou!

1 Answer 1

0

The newest available version certainly works with SQL Server 2022. You can install it in a different database than your current version (it can be tempdb or a dedicated database that you'll create for tests) and try it before replacing the old one (that's presumably in the master database).

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.