Applying a Lock to an Azure SQL Server can protect the databases in that SQL Server because child resources inherit locks from their parent, but this protection only applies in certain circumstances.
As an example, the following Azure SQL Server has a Delete Lock applied to it which protects its databases from deletion via the Azure Portal.
If I attempt to delete the test database in that SQL Server via the Azure Portal, I receive the following error.
However, if I connect to the Azure SQL Server using SQL Server Management Studio, I can successfully delete the database without removing the lock. Refreshing the Databases list in the Object Explorer confirms that the database has been deleted. The deletion of the database is possible whether you use T-SQL or the Object Explorer.
Be First to Comment