SQL Azure Backup and the Command Line

Comments 0

Share to social media

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.

Load comments

About the author

Grant Fritchey

See Profile

Grant Fritchey is a Data Platform MVP with over 30 years' experience in IT, including time spent in support and development. He has worked with SQL Server since 6.0 back in 1995. He has also developed in VB, VB.NET, C#, and Java. Grant has written books for Apress and Simple-Talk. Grant presents at conferences and user groups, large and small, all over the world. Grant volunteers for PASS and is on the Board of Directors as the Immediate Past President. He joined Redgate Software as a product advocate January 2011.

Grant Fritchey's contributions