Welcome!

.NET Authors: David Strom, Patrick Burke

Blog Feed Post

How to restore SQL Server database from Amazon S3 or Amazon Glacier
By Alexandra Brown
Article Rating:
March 6, 2013 03:26 PM EST
Reads:
 1,082
The recently released  CloudBerry Backup for SQL Server  helps the customers with no SQL Server administration experience can easily back up SQL Server databases to cloud storage such as Amazon S3 and Amazon Glacier.  It comes with all of the features of CloudBerry Backup Server edition plus and additional functionality to back up SQL Server.  In this blog post we will explain how you can restore MS SQL Server databases with CloudBerry Backup

How to restore SQL Server database with MS Management Studio

1. Open CloudBerry Explorer PRO http://www.cloudberrylab.com/pro
2. Select bucket with your backup files 
3. Copy backup file to the local drive (screenshots #1 or #2)


screen #1

screen #2
4. Open Microsoft SQL Server Management Studio
5. Select the database you want to restore | Tasks | Restore | Database 
6. In Restore Wizard select Restore "From device", click Browse button and add the backup file
7. Go to Options tab and select "Overwrite the existing database"
7. Click OK and restore the database (screenshots #3 or #4)

screen #3

Screen #4

Restore with SQL Scripts

If you don't have MS Management Studio installed you can still restore with the command line tools such as SQLCMD. Check out the example scripts below that will help you with the restore.
Restore full backup:

RESTORE DATABASE [database] 
FROM  DISK = N'C:\restore\database_full_20130305115443.bak' 
WITH  FILE = 1,  
NOUNLOAD,  
REPLACE,  
STATS = 10
GO

Restore differential backup:

RESTORE DATABASE [database] 
FROM  DISK = N'C:\restore\database_full_20130305115443.bak'
WITH  FILE = 1, 
NORECOVERY, 
NOUNLOAD, 
REPLACE, 
STATS = 10
GO

RESTORE DATABASE [database] 
FROM  DISK = N'C:\restore\database_diff_20130305130914.bak' 
WITH  FILE = 1,  
NOUNLOAD,  
REPLACE,  
STATS = 10
GO

Restore transaction log:

RESTORE DATABASE [database] 
FROM  DISK = N'C:\restore\database_full_20130305173505.bak' 
WITH  FILE = 1,  
NORECOVERY,  
NOUNLOAD,  
REPLACE,  
STATS = 10
GO

RESTORE LOG [database] 
FROM  DISK = N'C:\restore\database_log_20130305174255.trn' 
WITH  FILE = 1,  
NOUNLOAD,  
STATS = 10
GO

Final notes

In the future if we see a demand we will automate SQL Server restore with CloudBerry Backup and you will be able to use a single one tool to do the backup and restore.  

Pricing and licensing

CloudBerry Backup for SQL Server will cost $149,99 per server, but we are doing an introductory time limited offer at $119,99 per server.
In addition the customers using CloudBerry Backup Server Edition can upgrade CloudBerry Backup for SQL Server at $40 for the time of the special offer.
The customers using CloudBerry Backup Enterprise Edition ($299,99) can get the SQL Server functionality for free.  The newer version of the Enterprise Edition comes with SQL Server module.

As always we would be happy to hear your feedback and you are welcome to post a comment.
+++
Note: this post applies to CloudBerry Backup for SQL Server 3.3 and later.
CloudBerry Backup is a Windows program that leverages Amazon S3 storage. You can download it at http://www.cloudberrylab.com/backup. It comes with onetime fee of $29.99 (US) per copy.
CloudBerry Backup for WHS is a Windows Home Server add-in that leverages Amazon S3 storage. You can download it at http://www.cloudberrylab.com/whs. It comes with onetime fee of $29.99 (US) per copy.
CloudBerry Backup Server Edition.  is a Windows program designed to run in server environment that leverages Amazon S3 storage. You can download it at http://www.cloudberrylab.com/server. It comes with onetime fee of $79.99 (US) per copy.

Like our products? Please help us spread the word about them. Learn here how to do it.
Want to get CloudBerry Backup for FREE? Make a blog post about us!

Read the original blog entry...

Published March 6, 2013 – Reads 1,082
Copyright © 2013 SYS-CON Media, Inc. — All Rights Reserved.
Syndicated stories and blog feeds, all rights reserved by the author.

More Stories By Alexandra Brown

Marketing Manager at CloudBerry Lab, the company that specialize on tool that makes Cloud Computing adoption easier. CloudBerry Lab is established in 2008 by a group of experienced IT professionals with the mission to help organization in adopting Cloud computing technologies by closing the gap between Cloud vendors propositions and consumer needs through development of innovative low costs solutions.