Latest posts

Backing Up SQL Server Databases to Amazon S3

Backing Up SQL Server Databases to Amazon S3

If you run Microsoft SQL Server, you may wish to back up your databases to a cloud like Amazon Web Services (AWS). Doing so not only provides you with a virtually infinite amount of backup storage space in the cloud, but it can also make recovery easy in cases where you decide to restore your database using a cloud-based server.

In this article, we explain the main options available to you for backing up SQL Server databases to AWS. In particular, we’ll discuss backing up your data manually from a SQL Server database into S3, backing up data to AWS RDS and, finally, how to perform an image-based backup with the help of CloudBerry Backup.
Continue reading

SQL Server Database Backup

SQL Server Database Backup with CloudBerry

SQL Server Database Backup with CloudBerry

To keep your Microsoft SQL Server databases safe, you need to back them up. Today, it is considered a best practice to have at least two backup copies of all of your data, one on-site and one off-site.

In this article, we will demonstrate how CloudBerry Backup can provide both on-site and off-site backups of MS SQL Server databases by backing up data to both local storage and cloud storage.
Continue reading

SQL Server Database Restore

SQL Server Database Restore with CloudBerry

SQL Server Database Restore with CloudBerry

CloudBerry Backup supports backup and restore of Microsoft SQL Server databases. The product integrates with Microsoft SQL Server's built-in backup and restore mechanisms, provides SQL Server compression, and offers flexible scheduling, among a range of other useful options.

In this article, we’ll discuss how to restore SQL Server databases using CloudBerry’s solution. For instructions on the backup process, please refer to our article “SQL Server Database Backup.”
Continue reading

SQL Server Automatic Backup

Microsoft SQL Server Backup Automation

Microsoft SQL Server Backup Automation

The backup routine for MS SQL Server includes various repetitive tasks that require a lot of time and attention. Fortunately, there are built-in Microsoft SQL Server tools that can automate many of these steps and simplify your daily routine. This article discusses those built-in tools, while also showing how to use CloudBerry software for MS SQL Server automatic backup.

Continue reading

SQL Server Table Backup

How to Back Up a Table in Microsoft SQL Server

How to Back Up a Table in Microsoft SQL Server

Table-level backup is one of the most rarely used data protection types in Microsoft SQL Server. However, table backup is important in certain scenarios; for example, you may need to copy data into one single table in order to perform a data export or migration, or as part of a disaster recovery plan.

This article explains how to perform table backups in Microsoft SQL Server.

Continue reading

SQL Server Backup to Azure

Microsoft SQL Server Backup to Azure

Microsoft SQL Server Backup to Azure

In this article, we will provide an overview of methods for backing up Microsoft SQL Server databases to Microsoft Azure. This information is helpful for both backup and disaster recovery procedures. You will learn how to configure database backup to the cloud, how to implement a disaster recovery solution using Azure VM instances and how to back up SQL Server databases to the Azure SQL database service.

Continue reading

SQL Server 2008 Backup Guide

SQL Server 2008 Backup Guide

Microsoft SQL Server 2008 is still one of the most popular corporate database engines, and it has a lot of backup types supported. Let’s briefly remember all of these backup types and find out how to perform the most useful ones. After reading this post, you will know how to backup a database in SQL Server 2008 using query language or SQL Server Management Studio GUI. Continue reading