Category Archives: SQL Server Backup

Should You Back Up Your System Databases?

It goes without saying that as a DBA one of your most important tasks is to schedule and ensure regular backups of your databases. But by ‘databases’ here we usually mean your user-created databases. But SQL Server also automatically creates and maintains a number of system databases. So should you also back these up? Well, the answer isn’t a simple yes or no … Continue reading Should You Back Up Your System Databases?

Automated Database Backup-and-Restore for SQL Server

As a DBA, you have almost certainly taken a backup from one computer/ server for the purposes of restoration on another computer. It’s a somewhat tedious and manual process, but most of us are sort of resigned to it and accept it simply as a necessary evil of the DBA role. I mean, it’s not like you can automate the entire process, right? Well, hold that thought … Continue reading Automated Database Backup-and-Restore for SQL Server

SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified

Sometimes you may see “SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified” error message when connecting to a SQL Server and don’t know where to start. In most forums people say this is because remote connection is not enabled on the server. This is not exactly correct. Actually, this error message gives customers a very specific information and the solution is quite simple.

Continue reading SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified

POS System Backup Made Easy

POS Terminal backupA POS system backup is an essential task in any kind of business. Keeping your sales data safe for reporting and auditing is something all businesses should not cut corners in or treat with little importance.

When your company relies solely on an information system (database) to store all of its sales data, then it also must take all precautionary measures to protect this data and periodically make backups of the POS system’s database. We will show you how to do this in the article below.

Continue reading POS System Backup Made Easy

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

sqlbakSqlBak’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 Permissions

backup permissionsBackup permissions: This post will take you through the list of backup permissions a user needs to have in order to be allowed to make the most basic backup operation.

We will also explain what are some of the most advanced options for backing up databases and how you can give these privileges as well to some of your most trusted users.

Continue reading SQL Server Backup Permissions

SQL Server backup report

backup reportIn this article you can find a small script which 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