Backup History for SQL Server databases

 Backup HistoryHaving 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.

Read more

SQL Server 2014 for backups

 SQL Server 2014So, 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. 

Read more

Scheduling SQL Server Backups: A Comprehensive Guide

 
scheduling backupsScheduling 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.

Read more

What databases to backup?

databases to backupDoing backups might become a repetitive and reflex action if done for quite a long time. But due to this, you might skip a few things at the beginning and never add them to your checklist schedule when doing backups. 
The following article presents a list of databases to backup and reasons why you should do it.

Read more