You’re a systems administrator or database administrator who wants to protect your production SQL Server. However, you don’t have a separate data center or another colo site.
You’re looking for instructions on:
- How to copy your SQL Server databases to Google Cloud Storage
- How to spin up a SQL Server VM in Google Compute Engine to test your backups
- How to use our free scripts to restore your backups to the most recent point in time
- How to test the backups to make sure they’re corruption-free
Your goal here is a very, very inexpensive disaster recovery option. It won’t be a hot standby ready to automatically fail over – there’s going to be manual labor involved – but at least you won’t be starting from scratch.