Let’s assume that you have to administer over 100 databases that are stored on multiple servers. How can you make sure that every backup job is done as scheduled?
SqlBak
Destination error: “Access is denied”
In this article we would like to bring a very rare and interesting case to your attention. Assume you use SqlBak, everything is up and running perfectly, backups are made as scheduled and then stored in the folder you specified, everything seems flawless.
How often should I backup my database?
For almost any DBA, the question “How often should I backup my database?” is undoubtedly one of the most important to ask and answer. The answer, as with so many other questions in life, is “It depends”. Depends on what? Let’s discuss this.
Your data is secure with SqlBak
The safety of our customers’ data is always our priority above any of the features we have. We are constantly working on security improvements here at SqlBak. And the only data that is ultimately secure is the data that you never had in the first place. That is why we do not send, nor store your DBMS credentials on sqlbak.com at all. This means that your server login and password will never leave your server. This change will be especially welcomed by organizations whose privacy policy does not allow passing DBMS login and passwords to any third-party websites.
How to Backup SQL Server Database to Amazon Glacier
Amazon Web Services (AWS) offers a large, sometimes bewildering array of server, storage, networking, and analytics cloud offerings, as seen here. One of their storage products is Amazon Glacier, in addition to the older storage solutions – S3 and Elastic Block Store (EBS). Glacier is a very affordable solution intended as a write-once, retrieve-seldom storage medium for long-term storage. Think of it as a storage locker that’s far away from your home, as opposed to your at-home garage or cabinet locker. It is also a good choice for your SQL Server backups …
Why Transaction Log backups are important
When backing up your SQL Server database, you have the option of taking transaction log backups. These are quick, small backups containing a sequence of all your database’s changes. Transaction log backups are mightily useful for point-in-time recovery.
How to Manage Many SQL Servers with the new Dashboard
We have updated the SqlBak Dashboard – this is the main control panel where users can see all of their backup jobs on a single page. The new features will be particularly useful for customers who have many DBMS backup jobs. Let’s take a look at how these new features can make your life easier.
Automated Database Backup-and-Restore for SQL Server
As a DBA, you have almost certainly taken a backup from one server for the purposes of restoration on another server. 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 …
POS System Backup Made Easy
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.