Home > Uncategorized > Backing up a #SQL server Database to Amazon #S3 the easy way…

Backing up a #SQL server Database to Amazon #S3 the easy way…

tntdrive

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’

Advertisements
Categories: Uncategorized
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: