From the course: Microsoft Azure: Backup and Disaster Recovery

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Long-term SQL backups

Long-term SQL backups - Azure Tutorial

From the course: Microsoft Azure: Backup and Disaster Recovery

Start my 1-month free trial

Long-term SQL backups

“

- [Instructor] The next backup type that I'm going to show you is used to back up your Azure SQL databases. Now for some of you you may be thinking, wait, you told us in previous courses that Azure SQL databases had automatic backups. And you would be correct. But remember, the longest term retention period for Azure SQL databases is 35 days. Long-term backups for SQL allow you to back up weekly for up to 10 years. Let's go ahead and show you how we configure these. Now before we jump right in I'd like to point out what I already have set up here. In this resource group which I just called long-term SQL, I have a SQL server, a SQL database, and I have already configured the recovery services vault. And that's something to keep in mind when you're using the long-term backup, you cannot create it on the fly as you can do in some of the other backup solutions. Now we do want to back up the database so we'd think that we'd have to pop into the database, and we actually don't. We actually…

Contents