Category Archives: Database Backup

Category relating to database backups in SQL Server.

How to Backup SQL Server to Dropbox

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

How to Backup SQL Server to Google Drive

Backup SQL Server to Google Drive Since Google provides quite cheap storage and good interface it would be great to backup your Sql Backups 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 that 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 which 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 the 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

Backup TypesRegular 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

How to set up SQL Server Email Job Notifications

As a DBA, automating your various jobs on SQL Server – taking backups, truncating logs, updating statistics, etc – is a good idea because it makes sure you don’t have to depend on your feeble memory for these important tasks. And it leaves you free for more vital tasks such as sleeping and bingeing on whatever new Netflix series is out. But to make sure your automated tasks are still running, you need a good notification method, and it should also be automated. And foolproof. So how do you do this? Continue reading How to set up SQL Server Email Job Notifications