Seamless Data Recovery through Warehouse Restoration within Fabric Query Editor
In today’s rapidly evolving data management landscape, maintaining the resilience and continuity of your data infrastructure is essential. Unplanned system failures and scheduled maintenance alike demand the ability to restore data warehouses swiftly and seamlessly. This capability is no longer just a feature – it’s a critical necessity in modern analytics environments. A quick and reliable data warehouse recovery solution is indispensable, not only to protect against data corruption but also to ensure business continuity.
Earlier we released the ability to restore-in-place through REST API. We are thrilled to announce the capability to perform restore-in-place of a warehouse item in Microsoft Fabric through the Fabric Warehouse Editor. Let’s dive into how this vital functionality empowers data-driven organizations to navigate through disruptions with confidence.
System-created restore points
Fabric automatically creates system restore points for a warehouse at least every 8 hours. There will be a total of 160 system-created restore points at any given point in time.
Create user-defined restore points
Restore points are recovery points that can be leveraged to restore the warehouse. In addition to system-created restore points, you have the flexibility to create any number of user-defined restore points aligned with your specific business or organizational recovery strategy. Both the system-created and user-defined restore points come with a retention period of 30 calendar days, after which they will expire. Users can go to Warehouse Settings -> Restore points and Add a restore point by providing Name and Description.
Restore the data warehouse using restore points
Restore in-place is an essential part of data warehouse recovery which allows users to restore the data warehouse to a prior known reliable state by replacing or over-writing the existing data warehouse from which the restore point was created.
Each restore point references a UTC timestamp when the restore point was created. When you restore, the name of the warehouse remains the same, and the old warehouse is overwritten. All components, including objects in the Explorer, modeling, Query Insights, and semantic models are restored as they existed when the restore point was created. The data warehouse can be restored using either the system-created or user-defined restore points.
Rename user-defined restore points
The restore points can be renamed at any time through context menu actions by users.
Delete user-defined restore points
The user-defined restore points can be deleted anytime by users. Note: System-created restore points cannot be deleted by users. For more information, see Restore point retention.
View restore points
Users can also view both user-generated and system-created restore points. The information bar also provides details of the latest restoration and who it was performed by.
Conclusion
In conclusion, data warehouse restores are indispensable for effective data management, providing organizations with the capability to swiftly recover from unforeseen challenges. They are a proactive investment in ensuring organizational resilience. As the resilience of data increasingly mirrors the resilience of business, establishing a robust restore plan for data warehouses is not just beneficial but essential for organizational success. Explore this documentation for more details: Restore in-place in the Fabric portal.
