1

Can't seem to find any clear information about the following: will the LTR backup of an Azure SQL database be recoverable in the case of a complete SQL logical server deletion (could it be accidental or admin account compromise).

In other words, does the deletion of the whole logical SQL server would also delete the long-term retention backups?

What are you guys doing to protect against such threat? Database sync to another server & database? Scheduled script to backup the database to a .BACPAC file?

Thanks

SimonLeGeek
  • 35
  • 4

1 Answers1

0

You can mitigate the risk of deletion of the Azure SQL Database logical server in two steps:

  1. By giving users the minimum privileges which they must have for their tasks. You can manage permission of users regarding each element using the Access control (IAM).
  2. You can use Azure Resource Locks to avoid accidental deletion.
Martijn Pieters
  • 1,048,767
  • 296
  • 4,058
  • 3,343
Alberto Morillo
  • 13,893
  • 2
  • 24
  • 30