We are in the process of migrating our dbs from SQL 2016 to SQL 2019. I was having issues restoring the SSISDB on a dev server so decided to start fresh and deploy packages on new server instead. I deleted SSISDB, cleaned up job, and restarted services. I don't have the option to Create the Catalog now. Any ideas?
EXEC msdb.dbo.sp_delete_database_backuphistory @database_name = N'SSISDB' GO USE [master] GO /****** Object: Database [SSISDB] Script Date: 3/27/2023 1:35:55 PM ******/ DROP DATABASE [SSISDB] GO USE [msdb] GO /****** Object: Job [SSIS Server Maintenance Job] Script Date: 3/27/2023 1:45:30 PM ******/ EXEC msdb.dbo.sp_delete_job @job_id=N'b5d21d88-2f64-4474-ac44-9c0cad5f9173', @delete_unused_schedule=1 GO