New on the Database Blog: Storing SQL Server Backups in Amazon S3 Using AWS Storage Gateway
Over on the AWS Database Blog, there was a recent blog post focused on Storing SQL Server backups in Amazon S3 using AWS Storage Gateway that is helpful for our customers who manage storage environments as well. Many SQL Server database administrators and infrastructure teams write their database backups to file shares on Network Attached Storage (NAS), file servers or VMs today, which can consume a lot of on-premises storage capacity. This post provides prescriptive guidance on how to shift Microsoft SQL Server backups to AWS using a File Gateway configuration from Storage Gateway in a step by step process as outlined below.
- Deploy a File Gateway on-premises
- Join your Active Directory domain
- Create a file share (that actually front-ends Amazon S3)
- Mount the file share
- Backup your database to the file share (S3)
- Restore a database wherever you need it
We have seen many customers make this simple switch to back up their Microsoft SQL Server databases to Amazon S3 with this approach, reducing their on-premises storage footprint and leveraging S3 for durable, scalable, and cost-effective storage. After reading the short blog, you’ll actually be able to deploy and configure file gateway as a backup destination for SQL Server.