In the last couple of days I try to optimize some Azure environments from security and cost perspective. One customer has a SQL Server Express installed inside an Azure VM. The backup was configured for the hole VM, but there is no need to backup the Datadisk which contains the SQL databases. In this article I will explain how you can reinstall the Azure Backup Windows Workload extension to fix the issue when the service account will not listed on the Azure SQL Server VM. This fix the issue only did you not find the service account in the SQL Server management studio. To add the account in the right way, please refer to the article from Wim Matthysen.
Continue reading Reinstall Azure Backup Windows Workload to fix UserErrorSQL NoSysadminMembership for SQL Server in Azure VMCategory Archives: Azure Backup
Speaking at Cloud Eight Conference about 7 Best Practices for Azure File Sync
Update 1 on 22/06/2021
The recording of the session is now available on Youtube. I have added the link at the end of the article.
I am glad to announce that I was invited as a speaker to the Cloudeight conference. This is the 3rd edition of this conference and the conference is grown to a really big conference with a lots of great speakers and sessions. The conference itself was founded by Drago Petrovic as a free community driven conference.
I am very exited to deliver a session on 7 tips you need to know to use Azure File Sync perfectly. Azure File Sync is a perfect service to sync file servers across enterprise boundaries through a central Azure Fileshare. In this session, I will share the best practices to use Azure File Sync perfectly based on my real-world experience. I will cover the following topics:
Continue reading Speaking at Cloud Eight Conference about 7 Best Practices for Azure File SyncAzure VM Best Practices
Last year Gregor Suttie and Richard Hooper launched the Azure Advent Calendar and I got to support with a session on Azure Bastion. This year they improved on the idea with the Festive Tech Calendar. I’m happy to be back with an article on Azure VM best practices. I hope you find the article helpful and I would appreciate feedback.
Over the past few months, I have conducted many customer workshops, designed and implemented Landing Zones, and migrated or placed VMs into Azure. One of the most common customer questions has been about best practices for Azure VMs to maximize performance and efficiency, minimize costs, increase security, and reduce management overhead. This article is based on my real-world experience and recommendations based on several Azure projects.
Continue reading Azure VM Best PracticesMy favorite Azure Announcements from the Microsoft Ignite 2020
The Microsoft Ignite 2020 has moved to a free, virtual conference with a lots of online sessions about the Microsoft Product world like Azure, Microsoft 365 and more. As every year Microsoft announced new services and new features for existing services. In this blog post I will report about my highlights of the last 48 hours of Microsoft Ignite.
First of all, I’m a little sad because this was to be my first Microsoft Ignite I was able to attend in person. However, I’m glad that Microsoft offers this conference as a virtual version and gives us the opportunity to participate for free and get in contact with the product owners.
Satya Nadella opened the MS Ignite with his Keynote about Challenging Times, Producivity and Modern Work and how Microsoft services can help in every section with different services.
My focus area is Azure, you know it 🙂 And there were a lot of new announcements before and during the Ignite.
This article will be updated after the MS Ignite ends.
Continue reading My favorite Azure Announcements from the Microsoft Ignite 2020Move Azure VMs between Azure Global Regions
In the last couple of days I get a lot of question how to move Azure VMs between regions. So I decided to write a blog post about this question. First of all it is really important to understand which topics this article covers and which not.
To understand the article right, keep the follow settings in mind:
- This article will cover how to move Azure VMs between global regions with ASR
- Global regions mean all the standard available regions
- This article doesn´t cover the movement between Azure Global and Azure Germany, Azure Governance or China
- For moving Azure VMs from Azure Germany to Azure Global there there is planned to write an additional article
- For a general movement of Azure resources (SQL databases, Web Apps and more) a futher post will follow
This article focuses on how to move Azure VMs between Azure global regions using Azure Site Recovery (ASR). Another article will focus on how to move other Azure resources between regions.
General
To move Azure VMs between different global regions with ASR there are some requirements needed:
- Azure subscriptions are allowed to create Azure VMs in the target regions
- User rights to create the Azure ressources (Azure VMs, VNETs, NICs, etc.)
- Install latest updates on Windows/Linux OS
- Check that the VM has Internet access without Proxy or Firewall between VM and Internet
- When there is a firewall or proxy in place, check the needed requirements
- Configure the VNET and Subnet in the target destination before move the VM to a different region
The process to move Azure VMs between different Global regions is straight forward. But don´t forget, all related management tasks to the VM, like Backup, Log analytics Workspace, Start Stop Runbooks will be lost after the migration.
Continue reading Move Azure VMs between Azure Global RegionsSQL Backup on SQL Saturday – Sessioninhalte
Soeben ist meine Session SQL Backup on Azure auf dem SQL Saturday Rheinland zu Ende gegangen. Es war mir eine besondere Freude an der Hochschule sprechen zu dürfen.
Continue reading SQL Backup on SQL Saturday – Sessioninhalte
Backup SQL Server Datenbanken in Azure IaaS VMs #AzureBackup
Eines der häufigsten Azure VMs die ich bei Kunden antreffe ist die Installation eines oder mehrere SQL Instanzen innerhalb der VMs. Um die Datenbanken zu sichern waren bisher immer Umwege über MABS, DPM oder 3rd Party Backup Programme notwendig. Dabei ist bereits seit der Ignite 2017 das Azure Backup Feature “Backup SQL Server in Azure VM” in Private Preview und soeben in Public Preview gegangen und in allen Tenants verfügbar. Mit diesem Feature besteht die Möglichkeit SQL Datenbanken die innerhalb von Azure VMs auf installierten SQL Instanzen vorhanden sind, automatisiert direkt in den Keyvault zu sichern. Und das ganze ohne extra Tools oder Backupagents.
In diesem Beitrag werde ich die notwendigen Voraussetzungen, die Einrichtung und die Kosten vorstellen.
Bitte beachten der Service befindet sich derzeit noch in der Preview Phase.
Continue reading Backup SQL Server Datenbanken in Azure IaaS VMs #AzureBackup
Neues zu Azure File Sync – Regionen, Backup, FAQ und mehr
Azure File Sync steht seit der Ignite als Public Preview zur Verfügung. Bereits ende Oktober habe ich einen Artikel Überblick und Konfiguration erstellt.
Seitdem hat sich einiges getan, daher werde ich in diesem Artikel auf die Neuigkeiten eingehen.
Continue reading Neues zu Azure File Sync – Regionen, Backup, FAQ und mehr
Wichtige Neuigkeiten zu Azure Backup
Vor zwei Tagen sind einige, wichige Neuigkeiten für AzureBackup angekündigt worden, die ich hier nochmal kurz zusammenfassen möchte. Auch für mich als kleinen Reminder, da das Thema immer wieder bei Kunden interessant ist. 😉
Microsoft Azure Backup v2 verfügbar
Wer bisher Erfahrungen mit Azure Backup gesammelt hat, kannte auch die bisherige Einschränkung, kein Support für Windows Server 2016 weder als Host noch als Backup-Quelle. Diese Einschränkung gilt nicht mehr.
Microsoft hat gestern Azure Backup Server v2 frei gegeben. Microsoft Azure Backup Server (MABS) in v1 basierte auf DPM 2012 R2 und damit auf WS2012R2 und ist mit dem Modern Backup von Windows Server 2016 inkompatibel.