Click here to monitor SSC

Scarlet & Scary

SQL Azure Backup and the Command Line

Published Monday, September 26, 2011 3:00 AM

SQL Azure has no scheduling capabilities at all. If you want to schedule something like, oh, I don't know, a backup, you need to use SQL Agent or some other utility. In order to make that work, you need to use a command line. I've recorded a video on how I set up a SQL Agent job to run PowerShell scripts to backup my SQL Azure database. Check it out.

For an even better presentation on how to do this, go over to TJay Belt's blog and read several of his posts. He lays it out much better than my videos.

by Grant Fritchey
Filed Under: ,
You need to sign in to comment on this blog
Latest articles
A first look at SQL Server 2012 Availability Group Wait Statistics
 If you are trouble-shooting an AlwaysOn Availability Group topology, a study of the wait statistics... Read more...

SQL Server Prefetch and Query Performance
 Prefetching can make a surprising difference to SQL Server query execution times where there is a high... Read more...

SSIS Basics: Setting Up Your Initial Package
 When working with databases, the use of SQL Server Integration Services (SSIS) is a skill that often... Read more...

Checking Out SQL Backup Pro 7’s New Automatic Backup Verification
 Wouldn't it be great to offload the daily chore of checking the integrity of your production... Read more...

Chuck Lathrope: DBA of the Day
 Chuck Lathrope was a finalist for the Exceptional DBA of the Year award in 2009. We contacted him to... Read more...