Backing up a #SQL server Database to Amazon #S3 the easy way…
You may have all your code saved safely in Source control, but your data is not something that can easily be regenerated in the event of a hard drive failure, or simple fat fingered, update or delete statement without a where clause.
Backing up your databases to the same machine saves against typos, but it doesn’t save against a server outage, you really need to get your backups off the server. Amazon S3 is a good option, since it costs under 2p per GB (London datacenter)
| S3 Standard Storage | |
|---|---|
| First 50 TB / Month | $0.024 per GB |
Now, there are a million ways you could get your server backups to S3, you could use a batch file, a custom script, some c# … However, I tried our Tnt Drive, which maps a drive to your S3 bucket, and uploads your files asyncronously.
Then all you need to do, is to put your backup on the mapped drive (Z), with a script like
backup database db to disk = ‘Z:\db.bak’
