All posts by Radu Gheorghiu

About Radu Gheorghiu

Passionate SQL Developer on the journey of trying to become an expert in all things Data (storage, manipulation, gathering etc.) Information is power, and information can only be obtained from data. Thus, in order to harness the power of information, you must be a master of Data.

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

How to backup query results

backup queryIn this article we will talk about how to backup query results if you are using a database querying application like SQL Server Management Studio.

 We will cover multiple possibilities of backing up your results, from those built-in of SSMS (SQL Server Management Studio) to some workarounds we consider are more efficient.

Continue to read to find out how to achieve this…

Continue reading How to backup query results

Cannot perform a differential backup because current backup does not exist

 

cannot perform a differential backup
Encountering a  “Cannot perform a differential backup for database, because a current database backup does not exist” error might generate some confusion if you look into your backup log and can see that FULL backups have been successfully created.
This article will try to give you an answer as to why this happens and a solution, that will hopefully be applicable to your situation.

Continue reading Cannot perform a differential backup because current backup does not exist

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