Sign in to confirm you’re not a bot
This helps protect our community. Learn more

Automated backups, PITR, and Availability Groups with Arc-enabled SQL Server | Data Exposed

Microsoft Developer
588K subscribers
<__slot-el>
<__slot-el>
1.2K views 1 year ago #LearnSQL #SQL #AzureSQL
This demo features two of the capabilities unlocked with Arc enabling your SQL Server(s). The first one covers the built-in Automated backups and Point-in-time restore capability which allows you to configure a custom backup schedule and perform a point in time restore of your user databases. The second feature is in the High Availability space and gives you the ability to view your Always On Availability Groups that are configured on your Arc enabled SQL Server(s), view a real time status of each of those AGs - from synchronization to health state as well as perform a planned, manual failover, all from Azure portal. Chapters: 00:25 - Introductions 01:11 - Azure Arc described 02:00 - Automated backups and Point-In-Time restores 04:07 - Demo 07:29 - Always-On Availability Groups 08:44 - Demo 09:38 - Closing 📌 Let's connect: Twitter - Anna Hoffman,   / analyticanna   Twitter - AzureSQL, https://aka.ms/azuresqltw ✔️ Additional Resources: Wha …...more
...more
Automated backups, PITR, and Availability Groups with Arc-enabled SQL Server | Data Exposed
32Likes
1,202Views
2023Nov 27
This demo features two of the capabilities unlocked with Arc enabling your SQL Server(s). The first one covers the built-in Automated backups and Point-in-time restore capability which allows you to configure a custom backup schedule and perform a point in time restore of your user databases. The second feature is in the High Availability space and gives you the ability to view your Always On Availability Groups that are configured on your Arc enabled SQL Server(s), view a real time status of each of those AGs - from synchronization to health state as well as perform a planned, manual failover, all from Azure portal. Chapters: 00:25 - Introductions 01:11 - Azure Arc described 02:00 - Automated backups and Point-In-Time restores 04:07 - Demo 07:29 - Always-On Availability Groups 08:44 - Demo 09:38 - Closing 📌 Let's connect: Twitter - Anna Hoffman,   / analyticanna   Twitter - AzureSQL, https://aka.ms/azuresqltw ✔️ Additional Resources: What is Arc-enabled SQL Server: https://learn.microsoft.com/sql/sql-s... Automated backups and point-in-time restore: https://learn.microsoft.com/sql/sql-s... Inventory and real time status of Always On Availability Groups: https://learn.microsoft.com/sql/sql-s... 🔴 Watch even more Data Exposed episodes: https://aka.ms/dataexposedyt 🔔 Subscribe to our channels for even more SQL tips: Microsoft Azure SQL: https://aka.ms/msazuresqlyt Microsoft SQL Server: https://aka.ms/mssqlserveryt Microsoft Developer: https://aka.ms/microsoftdeveloperyt #AzureSQL #SQL #LearnSQL

Follow along using the transcript.

Microsoft Developer

588K subscribers