Posts

Showing posts with the label SQL Server

Backup SQL Server Online to EMC Atmos

Image
EMC Atmos is powering many cloud storage services. One of the use case that keeps coming up for cloud storage is backing up Microsoft SQL Server off-site to an online storage. EMC Atmos will be a good destination for SQL Server backups. Put cloud storage aside, there are two basic ways to backup SQL server. First one is SQL Server manager, you can use the SQL Server manager to manually backup SQL server to a local file. The second way is by using Volume Shadow Copy Service (VSS). SQL Server is a VSS producer so any application that is a VSS consumer can take the snapshot that SQL VSS writer produces and save it away. Now put the cloud storage in and in the context of EMC Atmos , there are two ways to backup SQL server to EMC Atmos too. If the existing backup mechanism is to produce local files, you can use Gladinet Cloud Backup to backup the local files to EMC Atmos. Gladinet Cloud Backup is also a Volume Shadow Copy Service consumer so it is capable of receiving what the SQL Server...

Convenient SQL Server Backup to Amazon S3

Image
Every SQL Server admin knows how to backup SQL Server. It is a very mature technology since SQL Server 2005 because it has built-in support for Volume Shadow Copy Service. It knows how to take a consistent snapshot of the database and produce the snapshot as files for backup applications to consume and store. With Gladinet Cloud Backup , SQL Server Backup to Amazon S3 or any other supported Cloud Storage Services such as Windows Azure or Open Stack is as easy as set-it-and-forget-it, while restore is as simple as point and click. (check Gladinet’s homepage for supported cloud storage services) Get Cloud Backup You can have cloud backup in two different ways. The first one is a standalone installer package. The second one is an optional add-on for Gladinet Cloud Desktop. This tutorial will use Gladinet Cloud Desktop add-on for illustration purpose.