Database Copy may cause Azure SQL Database to run out of transaction log space

Summary: This article describes how a Copy Database operation may cause the source database to run out of transaction log space. The client applications may then encountered the error 9002: “The transaction log for database ‘xxxxx’ is full due to ‘AVAILABILITY_REPLICA'”. This description is derived from an actual support case.   Scenario: Each day between…


Connect to SQL Managed instance

  SQL Managed instance is located inside a Vnet. The options to connect to it are : From the Azure Inside the same VNet (different subnet) From different VNet using VNet peering / Site-to-Site VPN / Express Route circuit (for cross-region connection) From on-premises . Using express Route or VPN Refer to this article for…

0