Simplify Your IT Infrastructure with Azure SQL Database
Organizations of all sizes are realizing cloud computing is as reliable as any physical server system they can use for their operations. Azure SQL Database simplifies IT infrastructure for organizations even further. Azure SQL Database is the intelligent, fully managed relational cloud database service that provides the broadest SQL Server engine compatibility, so you can migrate your SQL Server databases without changing your apps. Accelerate app development and make maintenance easy and productive using the SQL tools you love to use. Take advantage of built-in intelligence that learns app patterns and adapts to maximize performance, reliability and data protection. SQL Database is a high-performance, reliable and secure database you can use to build data-driven applications and websites in the programming language of your choice, without needing to manage infrastructure.
Azure SQL Database provides several business continuity features, including automated backups and optional database replication. Each has different characteristics for estimated recovery time (ERT) and potential data loss for recent transactions. Once you understand these options, you can choose among them, and in most scenarios, use them together for different scenarios. As you develop your business continuity plan, you need to understand the maximum acceptable time before the application fully recovers after the disruptive event, which is your recovery time objective (RTO). You also need to understand the maximum amount of recent data updates (time interval) the application can tolerate losing when recovering after the disruptive event, which is your recovery point objective (RPO).
SQL Database automatically performs a combination of full database backups weekly, differential database backups hourly, and transaction log backups every five to ten minutes to protect your business from data loss. If you’re using the DTU-based purchasing model, then these backups are stored in RA-GRS storage for 35 days for databases in the Standard and Premium service tiers and seven days for databases in the Basic service tier. If the retention period for your service tier does not meet your business requirements, you can increase the retention period by changing the service tier. If you’re using the vCore-based purchasing model, the backups retention is configurable up to 35 days in the General purpose and Business critical tiers. The full and differential database backups are also replicated to a paired data center for protection against a data center outage.
2W Tech is a Tier I Microsoft Cloud Solutions Provider and can help get your organization started reaping the benefits from Azure, including its SQL Database. Contact us today to start your Azure journey.
Azure Guide to Cross-Platform and Open Source
Interested in reading this article? Click the button below to download this asset.