Tag: Backups
-
SQL Server Backups to Azure Part 4: Managed Backups
You’re now reading the 4th and final post in my SQL Server Backups to Azure series. In previous posts I’ve described how to set up an Azure Storage Account, Blob Storage container and how to take SQL Server backups there. This time we’ll take a look at one more option that puts our backups on…
-
SQL Server Backups to Azure Part 3: Custom Backups
You are now reading the 3rd part of the 4 part series on backing up databases to Azure. In Part 1 we looked at some benefits of using Azure for your backups and in Part 2 we set up the Storage Account with the Block Blob storage container. In this post, we’ll take a look…
-
SQL Server Backups to Azure Part 2: Setting up the Storage Account
This is the second part of a 4 part blog post series about backing up SQL Server to Azure. If you wonder why you’d like to back up data to Azure in the first place, please read the Part 1 of this series that explains some benefits of using Azure for backups. In this post,…
-
SQL Server Backups to Azure, Part 1: Introduction
I’ve said it before, and I say it again: Understanding how database backups and restores work is one of the more important topics for DBAs to understand. This time we’ll approach the topic from the cloud, and more precisely, from the Azure perspective. Why cloud perspective, you might as? For one simple reason. Even if…
-
Moving data (back and forth) with backups
Backups, backups, and backups. That’s pretty much my answer to what should be the top 3 priority topics that any DBA needs to understand well. And that’s what we’re going to be looking at this post, backups! Backups play a vital and important role in keeping your data (and in some cases your career) safe,…
-
Fun with Filegroups
Filegroups are an interesting and useful (if not actually all that fun, despite the title) concept within SQL Server. They provide not just a way to group objects like tables together, but also provide a mechanism to help us to speed up the backup, restore, and recovery of the databases. And occasionally, they can even…
-
Difference between a backup and a valid backup
It took me a while to write the first post for 2017, but it has been rather hectic at the office since I moved inside the organization to quite a different role. However I noticed this story a while back and it has been haunting me ever since. Now if you are a DBA then you…