mountainss Cloud and Datacenter Management Blog

Microsoft SystemCenter blogsite about virtualization on-premises and Cloud


Leave a comment

Microsoft #SQL Server #Backup to Microsoft #Azure Tool

SQL Server Backup to Azure

Overview:

SQL Server 2012 SP1 CU2 and SQL Server 2014 have built in capability to back up to Windows Azure storage. The SQL Server Backup to Windows Azure tool provides the same functionality for previous versions of SQL Server. It can also be used to provide encryption and compression for your backups.

Using the 3-step wizard, you can specify a rule or set of rules that are applied to any SQL Server backup. One example of a rule could be to redirect all local backups to the specified Windows Azure storage. Another example of a rule would be to use compression or encryption for backups stored in a specific location.

Once you configure the rules, these rules are applied to SQL Server Backup files. If the rule is set to use a Windows Azure storage account, the tool redirects the backups to the specified Windows Azure storage account, but leaves a stub file in the local storage with metadata information to be used during restore.

 

Benefits:

  • Support for backups to Windows Azure Storage for SQL Server versions that do not have the built-in capability. Using Windows Azure storage for your backups has several benefits, such as providing off-site storage for disaster recovery, accessibility regardless of location, etc. For more information, see SQL Server Backup and Restore with Windows Azure.
  • Encryption support for SQL Server versions that do not have the built in capability. Currently only SQL Server 2014 has encryption support.
  • Compression support for SQL Server versions that do not have the built in capability. Currently, SQL Server 2008 supports compression in Enterprise edition only, but SQL Server 2008 R2 and later, encryption is supported on Enterprise and Standard editions.

SQL Server and Operating Systems Support:

This tool is supported on SQL Server 2005 or later, and Operating System versions: Windows Server 2008 or later for Servers, and Windows 7 or later for Client Operating Systems.

Here you can download the Microsoft SQL Server Backup to Microsoft Azure Tool

SQL logo


Leave a comment

Use Microsoft #Azure Backup for your Datacenter protection #HybridCloud #Sysctr

HybridCloud DPM

With Microsoft Azure Backup, you can protect application workloads such as Hyper-V VMs, Microsoft SQL Server, SharePoint Server, Microsoft Exchange and Windows clients to:
– Disk (D2D), giving high RTOs for tier 1 workloads
– Azure (D2D2C) for long term retention.
And, you can manage the protection of various protected entities (servers and clients) from a single on-premises user interface.

You can deploy Microsoft Azure Backup server as:
– A physical standalone server.
– A Hyper-V virtual machine – You can run DPM as a virtual machine hosted on an on-premises Hyper-V host server, to back up on-premises data.
– A Windows virtual machine in VMWare – You can deploy DPM to provide protection for Microsoft workloads running on Windows virtual machines in VMWare. In this scenario DPM can be deployed as a physical standalone server, as a Hyper-V virtual machine, or as a Windows virtual machine in VMWare.
– An Azure virtual machine – You can run DPM as a virtual machine in Azure to back up cloud workloads running as Azure virtual machines.

Try it yourself and download Microsoft Azure Backup Software here

Here you can find more Microsoft information about Backup and Disaster recovery

DPM to AzureBackup

Microsoft System Center 2012 R2 Data Protection Manager RU9 to Azure Backup Vault in the Cloud

What’s new in DPM in System Center 2016 Technical Preview

Here you can find the Microsoft Azure Storage Backup & Recovery Blog to keep you Up-To-Date

AzureBackup


Leave a comment

#Microsoft Azure Backup D2D and for Longtime Protection D2D2C #HybridCloud #Backup #Azure #Sysctr

Backup2Disk2Cloud

Microsoft Azure Backup Vault Services

With Microsoft Azure Backup, you can protect application workloads such as Hyper-V VMs, Microsoft SQL Server, SharePoint Server, Microsoft Exchange and Windows clients to:
– Disk (D2D), giving high RTOs for tier 1 workloads
– Azure (D2D2C) for long term retention.
And, you can manage the protection of various protected entities (servers and clients) from a single on-premises user interface.

You can deploy Microsoft Azure Backup server as:
– A physical standalone server.
– A Hyper-V virtual machine – You can run DPM as a virtual machine hosted on an on-premises Hyper-V host server, to back up on-premises data.
– A Windows virtual machine in VMWare – You can deploy DPM to provide protection for Microsoft workloads running on Windows virtual machines in VMWare. In this scenario DPM can be deployed as a physical standalone server, as a Hyper-V virtual machine, or as a Windows virtual machine in VMWare.
– An Azure virtual machine – You can run DPM as a virtual machine in Azure to back up cloud workloads running as Azure virtual machines.

Here you can download Microsoft Azure Backup

HybridCloud DPM

Microsoft Azure Backup Documentation


Leave a comment

Complete #Microsoft Azure Cloud Services Overview #Azure #Cloud #HybridCloud

Microsoft Azure opensource banner

Any developer or IT professional can be productive with Azure. The integrated tools, pre-built templates and managed services make it easier to build and manage enterprise, mobile, Web and Internet of Things (IoT) apps faster, using skills you already have and technologies you already know. Microsoft is also the only vendor positioned as a Leader across Gartner’s Magic Quadrants for Cloud Infrastructure as a Service, Application Platform as a Service, and Cloud Storage Services for the second consecutive year.

Read Gartner’s Magic Quadrant for Cloud Infrastructure as a Service, for Cloud Storage Services and for Enterprise Application Platform as a Service.

Here you will see an Overview of all the possibilities with Microsoft Azure Services for Hybrid and Cloud solutions :

Azure Portal 01

Try Microsoft Azure for Free

Let’s start with all the possibilities with Compute from the Microsoft Azure Cloud :

Azure Portal Compute 01

Microsoft Azure Virtual Machines

You got a lot of choice in Azure what kind of Operating System you want to choose for your Virtual Machine in the Cloud :

Like all kind of Linux Machines :

Linux in Azure

Linux VM’s

Microsoft VM

Microsoft VM’s or choose your Own uploaded images

There is also an OpenSource VM Depot available.

Here you can find an Overview of Microsoft Azure Virtual Machine in the Cloud

 Web and Mobile newWeb and Mobile Services

In today’s world it is all about mobility and Applications. On your work, at School, at Home, and even when you do Sport like biking or running. I think that’s why
Microsoft makes One Platform Windows 10 to get the best experience with Applications on every Device.
Making your own websites is really Easy with Microsoft Azure and is Cool to work with.

Azure Web Mobile 01

Web Apps with SQL or MySQL Databases

Azure Web Mobile 04

PHP,CMS,Blog,Marketing Web Apps are possible

Here you can find more documentation about Azure App Service

App Services

Here you can find more documentation about Azure Web Apps

Here you can find more documentation about Azure Mobile Apps

Here you can find more documentation about Azure Logic Apps

To run all those Web Apps in the Cloud you need Storage and capacity to store your data save in the Cloud with high security policies.
Microsoft Azure has all kind of diffenrent Storage in the Cloud for your data.

Data and Storage

Microsoft Azure Data and Storage

Learn about Azure Storage, and how to create applications using Azure blobs, tables, queues, and files :

Microsoft Azure Storage Documentation

Learn how to use this fully-managed, scalable, NoSQL document database service :

DocumentDBDocumentDB

Microsoft Azure DocumentDB Documentation

Learn how to configure, monitor, and scale your SQL databases in Azure. Documentation, tutorials and more :

Microsoft Azure SQL documentation

High throughput, consistent low-latency data access to build fast, scalable applications :

Microsoft Azure Redis Cache Documentation

Learn how to use StorSimple for primary storage, backups, archive, and disaster recovery :

Microsoft Azure StorSimple Documentation

Search-as-a-service for web and mobile app development :

Microsoft Azure Search Documentation

Learn how to use this fully-managed, scalable, data warehouse service :

Microsoft Azure SQL Data Warehousing documentation

Of course when you have a lot of data, you like to analyze it for the business and make good Reports or Dashboard to
make the right decisions. Microsoft Azure Cloud Services has Data and Analytics :

Data and Analytics

Microsoft Azure Data and Analytics

Learn to create Hadoop clusters, process big data, develop solutions using streaming or historical data, and analyze the results :

Microsoft Azure HDInsight Documentation

Learn how data scientists and developers can embed predictive analytics into applications :

Microsoft Azure Machine Learning Documentation

Learn how to run real-time data analytics and event processing :

Microsoft Azure Stream Analytics Documentation

Learn how to compose data storage, movement, and processing services into streamlined data pipelines :

Microsoft Azure Data Factory Documentation

Learn how to receive telemetry from millions of devices :

Microsoft Events Hub Documentation

Learn how to enable reliable and secure bi-directional communications between millions of IoT devices and applications:

Microsoft Azure Internet of Things (IoT) Hub Documentation

A Hot item is Internet of Things or IoT, connect devices, machines, just things because it’s possible to get data or BIGDATA to work with.

IoT

Microsoft Azure Internet of Things

Get Connected with your Device and read here all the information you need about Internet of Things

To get connected with Microsoft Azure we have Software Defined Networking (SDN) in the Cloud to make your Infrastructure work.

Networking

Microsoft Azure Networking

Learn how to configure and monitor virtual networks in Azure :

Microsoft Azure Virtual Networks Documentation

Learn how ExpressRoute creates private connections between your infrastructure and Azure datacenters :

expressroute-basic

Microsoft Azure ExpressRoute

Microsoft Azure ExpressRoute Documentation

Learn how Traffic Manager distributes user traffic to hosted services within or across data centers :

Microsoft Azure Traffic Manager Documentation

Learn about Azure Load Balancing :

Microsoft Azure Load Balancer Documentation

Learn to configure DNS zones and records :

Microsoft Azure DNS Documentation

Learn about secure cross-premises connectivity between Azure and your infrastructure :

Microsoft Azure VPN Gateway Documentation

Learn to create an Application Gateway :

Microsoft Azure Application Gateway Documentation

Media Services is coming more and more from Cloud Services and is video streaming and watching TV interactive.

Media and CDN

Microsoft Azure Media and CDN

Making Video workflows easy from the Cloud :

Microsoft Azure Media Services Documentation

Improve the performance of your website, media, or mobile service by moving content closer to your end users :

Microsoft Azure CDN Documentation

When you are still working on an On-premises datacenter only, Microsoft makes it’s easy to transform your datacenter into Hybrid Cloud Scenarios.
You can think of a Twin Datacenter for your Core Business Applications, or save your longtime protection data into an Azure Backup Vault.

HybridIntegration

Microsoft Azure Hybrid Integration

Learn how to integrate the enterprise and the cloud with BizTalk Services :

Microsoft Azure BizTalk Services Documentation

Learn about flexible messaging in the cloud :

Microsoft Azure Servicebus Documentation

Learn how to backup your Azure virtual machines, and how to send backup data to Azure for long term retention :

Microsoft Azure Backup Documentation

Learn how to orchestrate protection of physical and virtual machines :

Microsoft Azure Site Recovery Documentation

When you got your Azure Cloud Solution working, you want to manage your Identities to give them secure access to your Azure Solution.

Security and Identity

Microsoft Azure Security and Identity

Learn how to manage identity and access of services and applications :

Microsoft Azure Active Directory Services Documentation

Consumer identity and access management in the cloud :

Microsoft Azure Active Directory B2C

Your domain controller as a service :

Microsoft Azure AD Domain Services Documentation

Learn how to enable added authentication for cloud and on-premises applications :

Microsoft Azure Multi-Factor Authentication Documentation

To make those Microsoft Solutions Available for everyone, you need Developers and Developer Environments.

Developer ServicesMicrosoft Azure Developer Services

Learn how to detect issues, diagnose crashes and track usage of your mobile apps, and web apps hosted anywhere: on Azure or on your own IIS or J2EE servers :

Microsoft Azure VisualStudio Applications Insights Documentation

Developers can also work in the Cloud with Microsoft Visual Studio Online :

VisualStudio Online

Here you find all the information you need for Visual Studio Online for Developers

Cloud Services needs management by ITpro’s or by Developers to keep your Azure Solution Up-to-Date and get your business innovated.

Management

Microsoft Azure Management

You have all kind of Management as you can see in the above picture.

Learn how to collaborate, deliver and scale across the entire DevOps lifecycle :

Microsoft Azure Preview Portal Documentation

Start creating Azure Scheduler jobs and job collections, and using advanced concepts such as history and recurrence :

Microsoft Azure Scheduler Documentation

Learn how to simplify cloud management with process automation :

Microsoft Azure Automation Documentation

Learn how to transform machine data into operational intelligence :

Microsoft Azure Operational Insights Documentation

Learn how to manage cryptographic keys and secrets :

Microsoft Azure Key Vault Documentation

Container Apps

Microsoft Container Apps

 This is a super simple “getting started” experience for deploying single and multi-container Dockerized applications utilizing Azure Resource Manager templates and the new Docker Extension

 Here you see an Example of a Container App from the Marketplace on the Azure Blog

In Microsoft Azure you got also on every item a Marketplace with templates and solutions from Vendors and OpenSource communities.

Marketplace

Microsoft Azure Market Place

Here you go to the Microsoft Azure Marketplace website with almost 3500 products

Azure Marketplace website

For Students you have Microsoft Dreamspark where you can get some of the Microsoft Azure features for students for Free !

 Dreamspark Students

I Hope this Microsoft Azure Overview is helpful for you to make the right decisions for your business, Development or study 🙂
– James van den Berg

MVP System Center Cloud and Datacenter Management.


Leave a comment

#Microsoft System Center 2012 R2 DPM Scale-Out Protection #sysctr #SCDPM #Azure #HybridCloud

ScaleOut DPM 2012 R2 RU4High Level Design System Center 2012 R2 Backup with Azure

In this fast Hybrid Cloud world where a lot is changing, backing up your data is important for Enterprise organisations.
With System Center 2012 R2 Data Protection Manager you can do a lot. I made a High Level Design of our
System Center 2012 R2 DPM POD’s ( Dell PowerEdge R620 Server with MD1200 SAS Storage Enclosures ).
For the first time we skipped to buy a Tape Library for long time protection, we now backup to Microsoft Azure Backup Vault storage for long time protection. So we have no tape management any more.

When you have more System Center 2012 R2 Data Protection Manager Servers in your Datacenter, you can think of Scale-Out protection where you are more flexibel in your Datacenter to save your data.

Scale Out

Here you can read more about System Center 2012 R2 DPM Scale-Out protection

System Center Data Protection Manager (DPM) offers backup to Azure for long term protection by leveraging Azure Backup. The first step in configuring DPM-A (DPM backup to Azure) is to register the DPM server to the Azure Backup vault. This article explains how the registration process is greatly simplified and enhanced with Update rollup UR4 for DPM.
Till Update Rollup 3 (UR3), users were required to generate a self-signed certificate and upload this certificate to the backup vault through the portal. During the registration process, the certificate was used to register the server to the backup vault. While this process ensured security, it was a bit overwhelming.
With UR4, registration of the DPM server to the Azure Backup vault is simplified without compromising on the security by using a concept called “vault credential”. A vault credential is an authentication entity that can be downloaded from the backup vault on the portal. The vault credential is valid for 48 hours from the downloaded time and can only be used during the registration process to authenticate the server with the backup vault.

Here you can read more on Simplified workflow to configure backup to Azure from DPM

To Protect SQL Server 2014 using DPM 2012 R2

Two Powerful ways to use Azure to Back Up your Enterprise

teched_cloudos_componentsKeep thinking of  “how to save your Data”


1 Comment

#MVPBUZZ CloudOS Roadshow : System Center 2012 R2 DPM and #WindowsAzure Backup Vault Storage #sysctr

Friday, March 7, 2014 we had a Great event at Microsoft Netherlands called MVP CloudOS Roadshow :

MVP CloudOS RoadShow 2

MVP CloudOS RoadShow 1

Here you can find the information about the MVP CloudOS Roadshow

I spoke about Hybrid Cloud with Microsoft System Center 2012 R2 Data Protection Manager and Windows Azure Backup Storage in the Cloud of Microsoft.
Here you find the step-by-step guide for backup to Windows Azure and eliminate Tape Management :

What you need before you begin is the following :

  • A Microsoft Windows Azure subscription for the Backup Vault in the Cloud.
    When you don’t have a Windows Azure Subscription you can try it first here :Try Windows Azure
  • And On-Premisses you need a System Center 2012 R2 DPM Server with a secure Internet Connection.

First you have to make an Certificate on the DPM Server :

SDK 81

Download the SDK for Windows 8.1 here (You only need to install the SDK)

We need MakeCert.exe located in the following directory after installing the SDK kit for the Self-Signed Certificate.

Makecert

Copy Makecert.exe to the DPM Server to make the Self-Signed Certificate.
CommandRun as AdminOpen Command Prompt Run as Administrator and go to the directoy where Makecert.exe is located.
Type the following command for example :

makecert.exe -r -pe -n CN=AzureBackup -ss my -sr localmachine -eku 1.3.6.1.5.5.7.3.2 -len 2048 -e 01/01/2016 AzureBackup.cer

You can find more information about makecert.exe here

Now we have created the self-signed certificate, we will make the Backup Vault in Windows Azure :

Login on Windows Azure Management Portal : https://manage.windowsazure.com

Create Backup Vault 1Give the Backup Vault a Name and Region for the Storage and Click on Create Vault.

When the Windows Azure Backup Vault is created you can upload the self-signed Certificate.

Manage Certificate DPMUpload your certificate.

After this you have to download the Backup agent for System Center 2012 R2 DPM.

Download Backup AgentDownload agent from Windows Azure Backup Vault for the DPM Server.

When the Agent is installed go to the console of System Center 2012 R2 DPM.

DPM1Go to Management and Click on Register

DPM2Browse to the certificate

DPM3Select the self-signed Certificate AzureBackup

DPM4Fetching Backup Vaults from Windows Azure.

DPM5Select your Backup Vault

DPM6Select your proxy server for the secure Internet connection

DPM7Here you can manage your Internet Bandwidth

DPM8Set here your recovery folder settings.

DPM9Set your Encryption settings and Click on Register

DPM10DPM Registration with Windows Azure Backup Vault is Completed.

From here we can configure the protection groups with Windows Azure Backup Vault :

DPM11Edit Protection Group PG_FileVolume

DPM12Select the Shares or Disk Volumes.

DPM13Select your Online Protection Goals.

DPM14Update Group and the backup will be made to the Cloud Storage of Windows Azure.

DPM15

BackupVault Azure 1Here you can see your Usage Overview in Windows Azure

BackupVault Azure 2Here you see the Registered DPM Server for the Backup Vault in Windows Azure.


Leave a comment

Installing and Configuring #WindowsAzure Backup agent part 2 of 2 Hybrid #Cloud

WAB Icone

After we Created a self-signed certificate :


  • Download the Certificate Creation Tool (makecert.exe) from the TechNet Gallery.
  • Open an elevated command prompt (with Administrator privileges) and navigate to the location where makecert.exe is stored. Then type:
    makecert.exe -r -pe -n CN=CertificateName -ss my -sr localmachine -eku 1.3.6.1.5.5.7.3.2 -len 2048 -e 01/01/2016 CertificateName.cer
    The certificate will be created and stored in the same location.
  • In the vault, click Manage Certificate to upload the .cer file that contains the public key. Note the following:
    • If you register the server you used to run makecert.exe, you can browse for the certificate using the Register Server Wizard (after installation of the agent).
    • If you want to register a server that was not used to run makecert.exe, you must export the .pfx file (containing the private key) from that server, and copy it to the server you want to register, and import it into the Personal certificate store on that server. After the import, you can browse for the certificate using the Register Server Wizard (after installation of the agent).

Certificate Upload WAB

Upload here your Created certificate for your Windows Azure Backup Vault.

WAB 1

Select your Certificate and the Backup Vault of Windows Azure Backup.

WAB 2

Click on Generate Passphrase and enter the location.

WAB 3

The Windows Azure Backup Agent is registering the Server in Windows Azure Backup Vault.

WAB 4

Now you are ready to backup and restore for this Server to the Cloud 😉

In the next view steps you see how we make a Backup Schedule, Backup Now and make a restore :

Here you see the step by step installation of a schedule Backup with Windows Azure Backup Agent :

Schedule WAB 1

Click on Next to get started.

Schedule WAB 2

Browse and select your data for the Backup Job.

Schedule WAB 3

Specify the Backup time(s)

Schedule WAB 4

Set your retention time, you can choose of 7, 15 or 30 Days

Schedule WAB 5

Confirmation of the Backup Schedule, Click on Finish.

Schedule WAB 6

The scheduled Backup Job is successfully Created.

You can also make a Backup NOW with the following steps :

Backup Now WAB 1

Click on Backup

Backup Now WAB 2

The agent is taking a snapshot

Backup Now WAB 3

Backup is running and data is transferring to Windows Azure Backup Vault.

Recovery Point in WAB

The recoverypoint is made in Windows Azure Backup Vault.

The most important thing of a backup is that you can restore your data 🙂

Here you have the step by step procedure of restoring your data from Windows Azure Backup Vault (Cloud) :

Restore WAB 1

Specify the Server for restore.

Restore WAB 2

Click Next for Browsing for Files to Select for Restore.

Restore WAB 3

Select your date of the recovery point.

Restore WAB 4

Select the items to recover.

Restore WAB 5

Select the destination for the recovery job.

Restore WAB 6

Confirmation of the recovery Job, Click on Recover.

Restore WAB 7

The Recovery Job is transferring the selected data from Windows Azure Backup Vault.

Restore WAB 8

The Restore Job is successfully restored and I have my Photo’s back 🙂