Friday, February 27, 2015

SQL Server Backup to Windows Azure

There are several ways of storing your databases in the cloud, but what if you want to keep your databases on your local servers and just dip your toe in the cloud (apologies for the terrible mixing of metaphors)? Just because you haven’t decided to move all of your data to the cloud doesn’t mean you shouldn’t benefit from cloud services. In this post I’m going to have a look at using Windows Azure storage as a backup location for SQL Server. Cloud storage is a great option for backups because no matter what happens at your primary site, the cloud backup is always available.This is available in Windows Server 2012 Service Pack 1 Cumulative Update 2 and later.

The first step is to set up your Windows Azure account. If you don’t already have an account you can go here to create a free trial.

You now need to create some storage in the cloud. SQL Server uses the Windows Azure Blob Service for storage and will create new files as necessary, however, you must create a container to store the blob. Follow these steps to set up Azure stoarge and a container:

  1. Log in to your Windows Azure Management Portal here.
  2. At the bottom of the screen click the NEW button if the NEW pane is not visible. Click DATA SERVICES, click STORAGE and click QUICK CREATE. In URL type a name for your demo organization; I’m going to use gtasqlbackup. In LOCATION/AFFINITY GROUP select your region and click CREATE STORAGE ACCOUNT.
  3. To be able to access the cloud-based storage, and backup or restore your data, you need the access keys, so click MANAGE ACCESS KEYS at the bottom of the screen. Write down the STORAGE ACCOUNT NAME, PRIMARY ACCESS KEY, and SECONDARY ACCESS KEY and then click the tick to close the window.
  4. Now you need to create the container to store your backups. Click your storage account name and then click CONTAINERS. Click CREATE A CONTAINER and in NAME type something relevant for your backups; I’m going to type sqlbackup. By default the container is private and it makes sense to leave it as private in this scenario. Click the tick to create your container.

 

Now you need a SQL Server Credential to store the security information used to access your cloud storage. Follow these steps to set up your credential:

  1. Start SQL Server Management Studio and connect to the database engine instance that you are using for this demo. Click New Query.
  2. Type the following query:
    CREATE CREDENTIAL sqldemo
    WITH IDENTITY= 'gtasqlbackup' /* use the account name that you specified earlier */
    , SECRET = 'XXXXXXXXXXXXXXXXXXXXX' /* use one of the access keys that you wrote down earlier */
  3. Click Execute.

Now you’re ready to perform the backup with the following steps:



  1. Click New Query
  2. Type the following query:
    USE master
    GOBACKUP DATABASE [Finance] /* use your database name */TO URL = 'http://gtasqlbackup.blob.core.windows.net/sqlbackup/finance.bak'/* use your account name, container name, and backup name*/

    WITH CREDENTIAL = 'sqldemo' /* use your crential that you just created */


    GO


  3. Click Execute.

That’s all there is to it. To see a demonstration of a backup and restore, have a look at my demo:

SQL Azure Backup

45 comments:

sarah taylor said...

Thanks for sharing informative article on java application development. Your post helped to understand the career in Java. JAVA Training in Chennai

robin singh said...

Hi Admin, I went through your article and it’s totally awesome. You can consider including RSS feed for easy content sharing, So that you can drive huge traffic to your blog. Hadoop Training in Chennai | Big Data Training in Chennai

varshini devi said...

Thanks for sharing this niche useful informative post to our knowledge, Actually SAP is ERP software that can be used in many companies for their day to day business activities it has great scope in future.
Regards,
SAP training in chennai|SAP course in chennai|SAP Course in Chennai|SAP Training|SAP courses in chennai

savitha singh said...

The future of software testing is on positive note. It offers huge career prospects for talented professionals to be skilled software testers. Best software testing training institute in Chennai | Software Testing Training in Chennai | Software testing training institute Chennai

murali karthik said...

Thanks for your information. QTP provide most precise and independent review about a software application. This automation testing tool is ideal to determine the performance and validity of a software application. QTP Course in Chennai | QTP training

Stephen said...

Learning new technolgoy would help oneself at hard part of their career. And staying updated is the only way to survive in current position. Your content tells the same. Thanks for sharing this information in here. Keep blogging like this.

JAVA Training Chennai | J2EE Training in Chennai | Hadoop training in chennai

Andrew Son said...

Technology place a vital part in humans ecosystem. So in order to survive one must be up to date. Thanks for sharing this information in here. Keep blogging article like this. I have bookmarked this page for future reference.

Hadoop Training Chennai | Hadoop Training in Chennai | JAVA training in Chennai

Melisa said...

Thanks of sharing this post…Python is the fastest growing language that helps to get your dream job in a developing area. It says every fundamental in a programming, so if you want to become an expertise in python get some training
Regards,
SAS Training in Chennai|Angularjs training chennai|Python Training in Chennai|python training chennai|FITA Academy reviews

kanchana said...

Your blog is awesome..You have clearly explained about it ...Its very useful for me to know about new things..Keep on blogging..
Hadoop training in chennai

kanchana said...

Great blog..You have clearly explained about the concept..Step by step explanation is too good to understand..Its very useful for me to understand..Keep on sharing..
Software testing training in chennai

Gopi Perumal said...

I am following your blog from the beginning, it was so distinct & I had a chance to collect conglomeration of information that helps me a lot to improvise myself.
Regards,
CCNA Training in Chennai | CCNA Training Institute in Chennai | Best CCNA Training in Chennai

Fathima Fazal said...

Nice article to read and best one in nature..QTP Training in Chennai

Anu Priya said...

Excellent Stuff..QTP Training in Chennai | QTP Training Institute in Chennai | QTP Course in Chennai

Aasha said...

Wonderful bloggers like yourself who would positively reply encouraged me to be more open and engaging in commenting. So know it's helpful..

Email Marketing Chennai

Giri Mani 2 said...

Thanks for this blog. All screenshots can explain the full blogs easily. This is very easy to understand. Using this screen shots know the details becomes easy.
Digital Marketing Company in Chennai

Saki R said...

Expected and valid points are included in you blog.. I really liked and I got some clear ideas for improve my thoughts from well defined content... keep updating more for us... thanks for shared useful blog..
Java Training in Chennai

Sathya G said...


The blog was very awesome!! Thank you for sharing the blog with us. please keep on updating more useful informations...
Hadoop Training in chennai

Andrew Son said...

Hadoop is especially used for Big Data maintenance. It uses Hadoop distributed file system . Its operating system is in cross platform. Its framework mostly written in java programming language. The other languages which are used by hadoop framework are c, c++ (c with classes) and sometimes in shell scripting.Thank you..!!
Regards,
hadoop training in velachery | big data training in velachery

Devi.Angularjs said...

Java Training in Chennai | Java Training in Chennai | Dot Net Training in Chennai |
JavaScript Training in CHennai | Java Training Institutes | Single Page Application Development

Devi.Angularjs said...

I have read your blog its very attractive and impressive. I like it your blog.

Dot Net Training in Chennai | .Net Online Training | Dot Net Training in ChennaiDot Net Online Training | LINQ Online Training | ASP.NET Online Training

Devi.Angularjs said...

Java Training Institutes Java Training Institutes
JSF Training Institutes in Chennai JSF Training Institutes in Chennai Java EE Training Institutes in Chennai Java EE Training Institutes in Chennai J2EE Training Institutes in Chennai J2EE Training Institutes in Chennai | Core Java Training Institutes in Chennai

Devi.Angularjs said...

Hibernate Training Institutes in ChennaiHibernate Training Institutes in Chennai Hibernate Online Training Hibernate Online Training Hibernate Training in Chennai Hibernate Training in Chennai Java Online Training Java Online Training

Devi.Angularjs said...

Yeoman Training JavaScript Training in Chennai

Angular 2 Training in Chennai Angular 2 Training in Chennai

HTML5 Training in Chennai

JQuery Training in Chennai JQuery Training in Chennai

D3 Training in CHennai D3 Training ReactJS Training in CHennai ReactJS Training

Gulp TrainingGulp Training CommonJS Training in Chennai CommonJS Training

Devi.Angularjs said...

I have read your blog its very attractive and impressive. I like it your blog.
corporate training companies in india corporate training companies in india corporate training in chennai corporate training in chennai | corporate training institutes in chennai corporate training companies in chennai corporate training companies in chennai Angular 2 Corporate Training Angular 2 Corporate Training

Thulasi Raman said...

Thanks for Sharing the valuable information and thanks for sharing the wonderful article..We are glad to see such a wonderful article..
QTP Training in Chennai | QTP Training Institute in Chennai | QTP Training

Priya R said...

Excellent post!!!. The strategy you have posted on this technology helped me to get into the next level and had lot of information in it.
cloud computing training in chennai | cloud computing courses in chennai

Karthi Swetha said...

Great explanation!Your way of approach is understands clearly.Now we know how Using windows azure storage sql server backups are access. It will most valuable information in an my career.


Cloud Computing Training in Chennai

Priya R said...

Well Said, you have furnished the right information that will be useful to anyone at all time. Thanks for sharing your Ideas.
Web Designing Course in Chennai | web designing training in chennai

Gopi Perumal said...

Nice post...
SAP Training in Chennai | SAP Training Institutes in Chennai | Best SAP Training in Chennai

Arthur Mac said...

Wonderful post.This is really one of the most beneficial blogs I’ve ever browsed on this subject. I am very glad to read such a great blog and thank you for sharing this good information with us.
Regards,
ccna Training institutes in chennai | ccna Training in velachery

Gopi Perumal said...

Pretty article! I found some useful information in your blog, it was awesome to read, thanks for sharing this great content to my vision, keep sharing.
Regards,
PMP Training | PMP Training in Chennai

Priya R said...

Thanks for sharing this unique and informative content which provided me the required information.
Java Training in Chennai | JAVA Course in Chennai

Priya R said...

Well Said, you have furnished the right information that will be useful to anyone at all time. Thanks for sharing your Ideas.
PHP Training in Chennai | PHP course in Chennai

Melisa said...

Interesting Post! Thank you for sharing the recent technological updates.
Regards,
PHP Training in Chennai|PHP Course in Chennai

Anu Priya said...

Wow it is really wonderful and awesome thus it is very much useful for me to understand many concepts and helped me a lot. it is really explainable very well and i got more information from your blog.
Software Testing Training

Evangeline Mitul said...

This is a great post. I like this topic.This site has lots of advantage. It helps me in many ways.Thanks for posting this again.

Painless Dental Treatment In Chennai

Best Dental Clinic In Adyar

Savithaa Nirmal said...

Thanks for sharing the useful information with us. This information is impressive..I am inspired with your post writing style & how continuously you describe this topic. After reading your post,thanks for taking the time to discuss this, I feel happy about it and I love learning more about this topic.

Thanks
Practical oriented selenium training in chennai

Mehgna Sharma said...

Thanks for your great information. CCNA Summer Training in Noida

Krishna Veni said...

Nice and good article.. it is very useful for me to learn and understand easily.. thanks for sharing your valuable information and time.. please keep updating.



Software Testing Training in chennai

Aashi said...

I do believe all of the concepts you’ve introduced in your post. They’re very convincing and will definitely work. Nonetheless, the posts are too short for novices. May you please extend them a bit from subsequent time? Thank you for the post.
AWS Training in Chennai
Hadoop Training in Chennai
Digital Marketing Training in Chennai

Karthi Keyan said...

Interesting blog post.This blog shows that you have a great future as a content writer.waiting for more updates...

Digital Marketing Company in India

Digital Marketing Services in India

Digital Marketing Agency in India

Digital Marketing Companies in India

Digital Marketing Companies India

Digital Marketing Agency India

jeeva said...

Nice and good article.. it is very useful for me to learn and understand easily.. thanks for sharing your valuable information and time.. please keep updating.



Dot Net Training Institute in Chennai

Nithya said...

Your blog is awesome..You have clearly explained about it ...Its very useful for me to know about new things..Keep on blogging..

Regards:
Nithya,

Android Training Institute in Chennai

Swetha U said...

nice blog

PHP Training Institute in Chennai

USEFUL CHANNEL said...

It's more informative blog and useful also PHP training in chennai