This post has been republished via RSS; it originally appeared at: AzureCAT articles.
First published on MSDN on Sep 11, 2018
As more users migrate their SAP workloads to Azure, they will discover the benefits of migrating the Microsoft SQL Server data tier as well. Storing SQL Server data files on Azure can help speed migration, improve security, and provide high availability and disaster recovery. This guide by Ravi Alwani of AzureCAT addresses common questions from SAP users. It explains how to store SQL Server data files using Azure Blob Storage and set up file-snapshot backups, which provide nearly instantaneous backups and quicker restores for database files stored using the Azure Blob Storage service.
Download the 17-page whitepaper on Azure.com:
Basic Table of Contents (TOC):
- Introduction
- SQL Server data files on blob storage
- Use PowerShell
- Create credentials
- Create a test database
- Use Azure portal
- Use PowerShell
- File-snapshot backups for database files on Azure
- Back up database using file-snapshot backup
- Generate activity and backup logs using file-snapshot backup
- Restore a database to a point in time
- Learn more
AzureCAT Guidance
"Hands-on solutions, with our heads in the Cloud!"