Recover deleted data in SQL Server
Backup History for SQL Server databases
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.
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.
SQL Server 2014 for backups
How to schedule a backup cleanup
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 SQL Server Backups: A Comprehensive Guide
What databases to backup?
Doing 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.
How to export SQL table to Excel
This article shows three ways of how to move your data from SQL Server table or query to Excel or CSV file.
How to open a .bak file
You’ve recently come across a peculiar type of file with a .bak extension, and you know you are supposed to restore it in order to get the data.
This article will show you what to do in case you have such a file, and you need to open it to access the information.