- Professional Azure SQL Database Administration
- Table of Contents
- Professional Azure SQL Database Administration
- Contributors
- Preface
- 1. Microsoft Azure SQL Database Primer
- Azure SQL Database Architecture
- Azure SQL Database Request Flow
- Provisioning an Azure SQL Database
- Connecting and Querying the SQL Database from the Azure Portal
- Connecting and Querying the SQL Database from SQL Server Management Studio
- Activity: Provisioning Azure SQL Server and SQL Database using PowerShell
- Summary
- Azure SQL Database Architecture
- 2. Migrating a SQL Server Database to an Azure SQL Database
- Finding the Migration Benefits
- Finding the Blockers
- Selecting a Service Model
- Selecting a Service Tier
- Selecting the Main and Disaster Recovery Region
- Selecting a Migration Tool
- Azure SQL Database Service Tiers
- Determining an Appropriate Service Tier
- Determining Compatibility Issues
- Determining the Migration Method
- Summary
- 3. Backing Up the Azure SQL Database
- 4. Restoring an Azure SQL Database
- 5. Securing an Azure SQL Database
- Access Control
- Firewall Rules
- Managing the Server-Level Firewall Rules using the Azure Portal
- Managing the Server-Level Firewall Rules using Transact-SQL
- Managing Database-Level Firewall Rules using Transact-SQL
- Authentication
- Using Active Directory – Password to Authenticate to an Azure SQL Database
- Azure SQL Database Authentication Structure
- Authorization
- Creating Contained Database Users for Azure AD Authentication
- Groups and Roles
- Row-Level Security
- Dynamic Data Masking
- Proactive Security
- Summary
- Access Control
- 6. Scaling Out Azure SQL Database
- 7. Elastic Pools
- 8. High Availability and Disaster Recovery
- High Availability
- Disaster Recovery
- Summary
- 9. Monitoring and Tuning Azure SQL Database
- Monitoring an Azure SQL Database using the Azure Portal
- Tuning an Azure SQL Database
- Summary
- Index
Restoring an Azure SQL Database is different from restoring an on-premises SQL Server Database. In this chapter, you learned about the following restore options:
- Point-In-Time Restore
- Restore a deleted database
- Geo-Restore a database
- Restore a database from Azure Vault
- Import a BACPAC
Each of these options can be leveraged in different scenarios. For example, a Point-In-Time restore will help you recover from a corrupt database or accidental deletes, whereas importing a BACPAC helps you set up a development environment with the same schema and data across development, testing, and integration.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.