Azure : Direct SQL Server to Storage Account Backup

Introduction
Did you know you can back up (and restore) your SQL data to (and from) your Azure Storage Account? No… Check out the following article ; SQL Server Backup to URL

IC639738.jpeg

How does that look in reality?
Browse to your storage account and click on “Manage Access Keys”…
2015-09-04 10_30_23-Storage - Microsoft Azure

Copy the “Primary Access Key” to your clipboard…
2015-09-04 10_30_56-Storage - Microsoft Azure

Now head over to your SQL Management studio and create the following credential…

CREATE CREDENTIAL [https://kvaestest01.blob.core.windows.net/sqlbackup] WITH IDENTITY='kvaestest01', SECRET='Dnwkn...SydB...gfsZjm...TJ9Ew=='

  • Credential Name : The url of your backup location
  • Identity : The name of your storage account
  • Secret : The primary access key

And you will see it pop up in your objects…

2015-09-04 10_31_29-kvaestest01-6 - kvaestest.cloudapp.net_55099 - Remote Desktop Connection

Now we are ready for the action!

BACKUP DATABASE AdventureWorks2012 TO
URL = 'https://kvaestest01.blob.core.windows.net/sqlbackup/AV2012_01.bak'
WITH CREDENTIAL = 'https://kvaestest01.blob.core.windows.net/sqlbackup'
,COMPRESSION
,STATS = 5;
GO

One thing to note. You can only use one URL in your backup command. So multiple backup files for concurrency reasons is sadly not possible.

Have fun!

Advertisements

Azure : Deploying Point-to-site VPN

Introduction
This post will provide you with a high level outline how to set up a point-to-site VPN with an Azure virtual network. If you run into issues during the setup, browse to the last part of this post, as it contains some “gotchas” that we encountered in the past.

Point-to-Site VPN Setup
Browse to your virtual network, then “configure” and tick the “Configure point-to-site connectivity”…
2015-09-03 10_30_29-Networks - Microsoft Azure

Next up is to enter the local ip range your client devices will receive upon connection!
2015-09-03 10_47_38-Administrator_ Command Prompt

Client Connector
Now press save and upon success, you will find the download links of the VPN connector on the dashboard page.
2015-09-03 10_28_03-Networks - Microsoft Azure
Before you ask… there are NO non-windows agents available for download.

Authentication Configuration
In regards to the authentication, this is solely done via certificates. So I advise you to follow this guide

2015-09-03 10_30_53-Networks - Microsoft Azure

The guide will get you through the process of creating a root certificate and generating client certificates by using this root certificate. Along with the VPN software, you’ll be providing your users/partners/… an export of the client certificate. In turn, they will need to import this into their workstation.

The bumps on the road…
What are the issues you’ll run into?

  • Makecert? I don’t have this… Download the SDK and install the “Windows Software Development Kit. Afterwards you’ll find “makecert” in %Programfiles%\Windows Kits\8.1\bin\x86|x64.
    2015-09-03 10_35_07-Windows Software Development Kit for Windows 8.1
  • I installed the vpn software. What now? – The install runs and a terminal windows flashes. 2015-09-03 10_40_57-RD-APOC-VDC02Now you are in the dark… Not nice of Microsoft to be honest! Browse to “Control Panel”, “Network & Internet”, “Network & Sharing Center” and then “Connect”. Now you will see your VPN connection. If you have no connect button, go to “Set up a new connection or network”, select “Connect to a workplace” and select your VPN adapter… 2015-09-03 10_42_00-Connect to a Workplace Next is to connect to the VPN … 2015-09-03 10_42_23-RD-APOC-VDC02 and validate the functionality! 2015-09-03 10_42_49-Network and Sharing Center

I hope this helped you on your journey in Azure!