Over many years working on a wide range of SAP projects, one of my chronic frustrations has been applying maintenance.

Often, we performed maintenance during outage windows that were too short. And they always seemed to be scheduled on weekends. Of course, we always made sure there was a system recovery point, the backup was fully complete, and the transaction logs were available,

If a backup failed for any reason, then it was more than likely the work would be called off and rescheduled. The actual backup process was not a trivial level of effort.

Solving Backup Hassles 

Wouldn’t it be great if backups took seconds instead of hours? If you could get multiple points of restore during the maintenance window? It’s possible with the Pure Storage® FlashArray™ Management Extension for Microsoft SQL Server Management Studio (FA SSMS Extension).

The FA SSMS is a host-based integration that executes on the Windows Server to manage SQL Server backup and restore operations. It supports application-consistent snapshot creation using the Pure Storage Volume Shadow Copy Service (VSS) Hardware Provider.

This extension can be used from the Microsoft SQL Server Management Studio (SMSS).

You can also automate it using the Pure Storage Backup SDK Windows PowerShell module. So SAP Basis administrators can manage the backup and restore operations on local and remote databases from a centralized SSMS deployment. The result: Maintenance doesn’t need storage, server, or database team input. Reliable, secure backups just run automatically.

Manage SQL Server Backup and Restore Operations for SAP

Traditionally, an SAP maintenance window followed the Restore path (depicted in the diagram below)

  • The first step is performing a lengthy backup to provide a restore point if any of the subsequent steps failed.
  • If a subsequent step did fail due to the duration of the restore,  you’d need to return the system to the prior status
  • Then, you’d need to organize a new maintenance window

Let’s face it. The traditional process is costly in terms of the time and money it takes to reorganise the entire maintenance window.

SAP Backup and Restore with SQL Server

 Backup in Seconds? Restore in Minutes? Yes!

How can Pure claim to deliver backups in seconds and full restores in minutes? It’s quite simple. With Pure Storage snapshots and the FA SMSS extension, you can create a restore point after the successful completion of a maintenance step. (You can see the flow in the diagram below.)

This process makes it easy to attempt a restore at any failed step, which can be done by simply shutting down the SAP system and using the FA SMSS extension to apply the previous backup (snapshot). It only takes seconds. Then, you can restart SAP. That’s it.

Additional References

Pure Storage FlashArray Management Extension for Microsoft SQL Server Management Studio

Varacel: “SAP System copies went from 2 hours to 8 sec”

Die Ziegleerschen : “Snapshots are fast & simple, despite 2TB size.”