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.  


Gerelateerde blogberichten

Seamless Data Recovery through Warehouse Restoration within Fabric Query Editor

oktober 4, 2024 door 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”

september 26, 2024 door Jovan Popovic

We’ve improved the JSON support in Fabric Datawarehouse (Fabric DW) and have added the following features in Fabric DW: The JSON_PATH_EXIST function checks if there is a value on the given path in JSON text. The JSON_OBJECT and JSON_ARRAY functions enable you to more easily create JSON objects or arrays based on a set of … Continue reading “Announcing improved JSON support in Fabric DW”