Microsoft Fabric Updates Blog

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.  


Entradas de blog relacionadas

Seamless Data Recovery through Warehouse Restoration within Fabric Query Editor

octubre 21, 2024 por Ambika Jagadish

In the era of Generative Artificial Intelligence, data warehouses play a pivotal role for organizations to store, manage, and analyze massive amounts of data. They serve as the foundation for business intelligence and help make informed decisions. However, like any technology, data warehouses are not immune to failures – whether from hardware malfunctions, software bugs, … Continue reading “Ensuring Data Continuity in Fabric Warehouse: Best Practices for Every Scenario”

octubre 4, 2024 por Jason Himmelstein

We had an incredible time in our host city of Stockholm for FabCon Europe! 3,300 attendees joined us from our international community, and it was wonderful to meet so many of you in person. Throughout the week of FabCon Europe, our teams published a wealth of valuable content, and we want to ensure you have … Continue reading “Fabric Community Conference Europe Recap”