In this article, we will present you the main idea behind the SQL Server backup to URL feature which has been available since the 2012 SP1 CU2 version.
This backup operation can be performed either from Powershell, T-SQL, or SMOs (SQL Server Management Objects), but in this article we will present you just the version with T-SQL.
You might have heard of this term, but you don’t know what it actually presumes.
Read this next article to understand what a copy-only backup is and how it fits in the big picture of SQL Server.
The way you set the expiration date on a backup for SQL Server databases is quite easy.
You have two options for doing this. In order to find out, read the following article where we will show you both options.
You might have heard of mirror backups, but you don’t know what they are exactly?
Well, in this article we will try to explain in the best way possible what they are, if you should use them and when you should use them.
Media errors during backup or restore operations are quite stressful because usually, these tasks should run smoothly.
But just in case you happen to have one such error, then it would be ready if you would be prepared or have a bit of knowledge about these errors before you see them.
Partial backups are a type of backup which was first introduced with SQL Server 2005.
These types of backups were designed for use with the simple recovery model in order to improve flexibility in terms of backing up very very large databases that can contain at least one read-only filegroup.
This article will go over the topic of how to back up files and filegroups in SQL Server using either SSMS or T-SQL queries.
Continue reading in order to find out why and when you should backup files and filegroups.
Having a complete backup history of all of your backup and restore operations can become quite useful at times.
All the data that you might need to be related to this, like who created the backup, at what time, on what media, and many other details are stored in the system databases of the SQL Server instance.
So, SQL Server 2014 CTP2 has been released and now we can have a look at some of its new features before its official commercial release later this year.
What we’re mostly interested in is, obviously, improvements related to backups and restores. Here is a shortlist with improvements.
This post is a continuation of a previous post where we explained how to do a maintenance plan which will take care of creating backups via a schedule. Now that we have a schedule that consistently creates backups, we might want to create a backup cleanup schedule to remove older backup files.