How to setup Microsoft SQL Server High Availability with AlwaysOn in Azure
- Automatic backups – This is the most commonly used and recommended option. These backups run when the system’s resource usage is less, to ensure that the system’s speed is not affected during normal working hours. The fact that users need not manually do the backup plays in it’s favor.
- Routine backups – These backups follow a specific schedule when the data might still be in usage. The schedule is flexible, and can be changed according to the user’s convenience.