Where do you store your backups? Do you store them in the local folder or somewhere in the cloud? How long does it take to make SQL Server database backup and then to move it to, for example, Dropbox? Why not just simply use SQLBackupAndFTP for automatically making scheduled SQL Server backups to Dropbox? It makes your life much easier. Continue reading How to Backup SQL Server to Dropbox
Category Archives: SQL Server
How to Backup SQL Server to Google Drive
Since Google provides quite cheap storage and a good interface it would be great to backup your SQL Server to Google Drive, wouldn’t it? But making SQL Server backups directly to Google Drive regularly with the help of T-SQL Commands isn’t as easy as it may look at first. Anyway, it is really easy if you are using SQLBackupAndFTP. Continue reading How to Backup SQL Server to Google Drive
Hot Questions Related to SQL Server Backup
We have noticed that users sometimes have different questions while working with SQL Server which on the one hand are easy and simple and on the other, they try to avoid asking them. In this post, we are going to answer some of the most common questions. Continue reading Hot Questions Related to SQL Server Backup
Is your Database Backup Strategy Perfect?
We encourage you to take your database backup strategy very seriously because it is crucial for keeping your data safe and sound. In this article, we are going to explore things that will make sure that you choose the best backup strategy for your SQL Server database. Everyone knows that before considering database backup strategy it is necessary to consider Recovery Point Objective (RPO) and Recovery Time Objective (RTO). But this is not an exhaustive list, here we have prepared some more questions, answers to which will enable you to create a backup strategy that will meet all your needs and expectations. Continue reading Is your Database Backup Strategy Perfect?
Giveaway: SQL Server Formatting Types Cheat Sheet
SQLBackupAndFTP.com presents you a free SQL Server Formatting Types Cheat Sheet. We spent several hours composing it for you.
SQL Server Backup Types
Regular backups are required to protect your database and ensure its restoration in case of failure. Various backup types provide different protection to your database. The most popular database backup types are full backup, differential backup, and transaction log backup. Before you create your own backup plan you need to consider two things: your recovery point objective (RPO) – how much data can you afford to lose? And your recovery time objective (RTO) – in case of disaster, how much time can you spend restoring your database? Now let’s check out some of the backup types. Continue reading SQL Server Backup Types
SQL Differential Backup
The crucial difference between SQL differential backup and a full backup is that differential backup includes all data that have been changed since the last full backup despite the fact that they have been included in the previous differential backup. Continue reading SQL Differential Backup
Unable to Create Restore Plan Due to Break in the LSN Chain
Sometimes when you restore your database backup you can get an “Unable to Create Restore Plan Due to Break in the LSN Chain” error. Let’s see how to deal with it. Continue reading Unable to Create Restore Plan Due to Break in the LSN Chain
Database Backup Software for MS Sql, MySQL, PostgreSQL
It’s no secret that scheduled backups are the best way to protect your database from disaster. In this article, we are going to explain, which database backup software is used for different database systems. Continue reading Database Backup Software for MS Sql, MySQL, PostgreSQL
SQL Server Express Backup
While it’s easy to create SQL Server Express backup with SQL Server Management Studio it’s quite difficult to run it regularly since SQL Server Express edition lacks handy job scheduler maintenance options in comparison with the full version of SQL Server. Here is where third-party backup utilities like SQLBackupAndFTP enter the stage. Continue reading SQL Server Express Backup