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.
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.
Traditionally, an SAP maintenance window followed the Restore path (depicted in the diagram below)
Let’s face it. The traditional process is costly in terms of the time and money it takes to reorganise the entire maintenance window.
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.