Category Archives: Backups

How to export data from a .bak file to Excel

bak_to_excelWere you ever faced with the situation in which you had to extract and export data from a .bak file to Excel (.xls, .xlsx or .csv format).

Surely if you have arrived here you are facing this problem and looking for a solution. Well, you have come to the right place. In the article below we will show you how you can achieve this.

Continue reading How to export data from a .bak file to Excel

SqlBak update: The New Dashboard

SqlBak’s dashboard has been upgraded to be more user intuitive interface, in order to provide the most essential information in just a quick glance as well as making modifications to the job.

It’s still very easy to create backups, to schedule them, to set custom backup destinations, and of course, all of the other features you will need to make sure your backup process is up to the highest standard. Let’s have a look!

Continue reading SqlBak update: The New Dashboard

SQL Server backup report

In this article, you can find a small script that you can use as a small cheat to have access to a on-the-go backup report of your databases.

If you can connect to your database, you can run this query and find out when was the last time your databases were backed up

and when were the last times a FULL, Differential, or Transaction Log backup was taken.

But what do you do when you do not have remote access to your databases, but still like to have a quick review of your last successful backups? Well, we’ll cover this too…

Continue reading SQL Server backup report

How to backup a SQL Server database to NAS drive

backup a sql server database to nas
In order to backup a SQL Server to NAS drive, all you need is to use SqlBak.
Backups are very important, and many organizations have different standards and rules for storing backups, from the more constrained from a security point of view which require you to store them locally (on premises) to the organizations that allow their DBAs to store backups of their databases onto cloud storage services.
For those organizations that choose to store their backups locally, there are multiple storage solutions, one of which is owning your own NAS.
Continue reading How to backup a SQL Server database to NAS drive

How to store FULL SQL Server backup on Amazon S3 and Differential backup on FTP

store FULL SQL Server backup on AmazonIn order to organize the types of backups you make from your databases, you have multiple options when using SqlBak.
 If you want, for example, to store FULL SQL Server backup on Amazon and differential backups to your FTP folder, SqlBak allows you to do this.
In the below article we will show you how to do this, fairly easily, through the Task Schedule screen.
Continue reading How to store FULL SQL Server backup on Amazon S3 and Differential backup on FTP

How to verify SQL Server backup files after a backup

verify SQL Server backup
It’s important to verify SQL Server backup files after the backup process is complete.
Although the process can finish successfully this does not guarantee that the integrity of the data in the backup file is valid.
This will definitely cause some annoyance when later trying to restore the backup file.
In order to avoid this unwanted scenario, you should use verification options …
Continue reading How to verify SQL Server backup files after a backup

SQL Server DB restore from Differential or Transaction log backup to another computer

Restore from Differential or transaction log backup
Restoring a SQL Server database from a Differential or Transaction log backup can’t be simpler when using SqlBak.
All that you have to do is press a few buttons and the restore operation will be complete. Read the article to find out how.
Continue reading SQL Server DB restore from Differential or Transaction log backup to another computer