Restore Point

  • Back Up and Restore a Fabric Lakehouse

    Jon wearing a black and purple Purple Frog Systems polo shirt, standing in front of a graphic background featuring hexagonal patterns and an image of a lakeside house surrounded by trees. Text on the image reads: “Back Up and Restore a Fabric Lakehouse.”

    Fabric Lakehouses have been around for a while, but they still offer no native way to back them up or restore them. Fortunately, the way Lakehouses are structured makes it possible to build your own backup process. A Lakehouse is split into two areas: Files and Tables. The Files area is straightforward, you can download and back up these items directly. The Tables are powered by Delta tables, which are made up of two key components: the…

    » Read more
  • How to Effectively Restore a Table in a Fabric Warehouse

    How to Effectively Restore a Table in a Fabric Warehouse

    If you’ve ever used a database, you’ve probably experienced that heart-jolting moment when you accidentally drop a table or run an update statement without a WHERE clause. In that instant, the table is either gone or potentially corrupted beyond repair. Fortunately, there are ways to recover data, depending on the environment you’re working in. In traditional databases like on-prem SQL Server, or other systems that rely on physical…

    » Read more