If I would have simply read the documentation (https://docs.microsoft.com/en-us/sql/t-sql/language-elements/try-catch-transact-sql?view=sql-server-ver15) the answer to my problem is answered.
Read MoreA high availability SQL Server BDC uses the Virtual Device Interface (VDI) to seed databases to secondary replicas.
Read MoreThis blog post focuses on connecting to the SQL Server BDC, some helpful log files and utility outputs. Understanding a few basics about a SQL Server BDC and the Contained Availability Group (containedag) makes managing and troubleshooting easier.
Read MoreThe dbcc clonedatabase is a handy command to clone metadata and information such as query disk store. Then you can use the database for various activities …
Read More