A cloud based, software provider in the health care industry came to us recently with an interesting challenge. The contract that this company signed with their clients, required them to provide on demand data access to each client whenever the client needed it. As the software providers application ran outside of their clients data center, this provided a handful of challenges:
This customers existing process involved taking native SQL Server backups, using manually scripted backup jobs, each of which needed to be customized based on the customers tier, and SLA requirements. Once the backups were complete, a separate third party utility was used to encrypt the backup data. Once encrypted, this file was copied to an accessible location, frequently via FTP. Lastly, the customers (some of which were non-DBA's, unfamiliar with the SQL Server restore process) were provided with a custom developed script that would perform the restore for them.
LiteSpeed for SQL Server offered the following capabilities to the customer, which would serve to dramatically streamline this process.
If you share any of these challenges around maximizing storage savings, speeding up backup and restore operations, centrally managing backup processing, or simplifying the process of recovering backups, I'd encourage you to take a look for yourself.
LiteSpeed for SQL Server is available for download, with a fully functional 14 day trial.
Also available on the mentioned product page, is a Top features list, for those that would like to learn more about LiteSpeed's capabilities before giving it a try on their own systems.