2

You can keep the Agent enabled but disable the individual jobs on ServerB and create a dedicated job on ServerB that continuously runs (or schedule it to run every X amount of time) and checks if the current server is the Primary. If it is, then enable the other jobs with sp_update_job. You can also check which jobs are enabled with msdb.dbo.sysjobs so your ...


2

Is there a means to perform the restoration if I do not know the encryption key? No. Currently if you lose the old server you lose the database. So immediately decrypt the database and take a backup. The SQL Server service account has access to the Server Master Key, which grants access to the Database Master Key in the Master database, which in turn ...


2

Background: On a stand-alone Windows 2016 server, we had three SQL Server Express instances: 2019, 2016 and 2014. All were installed at about the same time (2019 first, then 2016 then 2014). After completing some data migration tasks, we no longer needed 2014, and uninstalled it. Problem: SQL 2016 would no longer start on Windows start-up, but started fine ...


Only top voted, non community-wiki answers of a minimum length are eligible