Backups Archives - Page 10 of 10

Scheduling backups – SQL Server

December 23, 2021February 26, 2014 by Omelchenko Alexander

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.

What databases to backup?

December 23, 2021February 23, 2014 by Omelchenko Alexander

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

December 23, 2021February 23, 2014 by Omelchenko Alexander

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

December 29, 2021February 22, 2014 by Omelchenko Alexander

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.

Backup best practices – a shortcut

December 29, 2021February 1, 2014 by Omelchenko Alexander

We already know that backups are important for securing your databases from data loss.

We also have an article about best practices regarding backups, but the article is quite detailed and if you want to take a shortcut and take care of the essentials, then you’ve found it.