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.
So, in our previous articles, we introduced you to what is SQL, for what it is used, how it stores data in databases and tables, and how it works through commands (SQL query), and how the commands are different based on what SQL type you use.
Now that we have the overview, we are going to dive into writing our first SQL command, which in technical terms is called a query, as you might already know.
If you ever have the misfortune of having data deleted from the production database, don’t get upset as there is a way you can recover most of the missing data with the aid of Transaction Logs and LSNs (Log Sequence Numbers).
Here is a step-by-step solution on how to achieve this.
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.
At the time this article was written only SQL Server 2014 CTP2 was available, so information related to this subject is limited to only what was known from the perspective of the CTP2 edition.
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.
Scheduling the backup operations should be one of the elements that are imperative in the work of any DBA.
This simple action will save you lots of time and effort in the future. Scheduling backups can be done through the visual interface of SQL Server Management Studio (SSMS) as we will see next.
