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?
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
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.
A 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.
If you’re looking for an easy way to quick restore a database backup then you have found the right place.
Take a look at the article below to find out how you can achieve this.
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.
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!
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.
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…