All posts by Alex

How to Backup SQL Server to Dropbox

dropbox logoWhere 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

How to Backup SQL Server to Google Drive

Google Drive iconSince 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

Is your Database Backup Strategy Perfect?

Untitled drawing (7)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?

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