#Azure – DB Cloud TECH

April 22, 2020April 22, 2020 Mustafa EL-Masry #Azure, Azure Data Studio

How to Manage Azure with PowerShell Command from Azure Data Studio

All of us know Azure Data Studio is new Microsoft tool like SQL Server Management Studio but with highly advanced features like Azure Data Studio Notebook, one of the features that you can PowerShell extension on Azure data Studio to connect to your Azure Portal and do your homework easily, Azure data studio PowerShell extension supported PowerShell and Cloud Shell (CLI) AZ Command, did you imagine this powerful tool from one place you can write your T-SQL, PowerShell, and CLI and you can manage your SQL Server on Premises and your Azure SQL and the other Azure services, all of these services and these languages from one place Using Microsoft Azure data Studio 🚀💪😱

IF you need to check all of my azure posts ➡ Latest Microsoft Azure Articles and Posts

Managing Azure With PowerShell From Azure Data Studio

Connect to Azure with PowerShell from Azure Data Studio

Continue reading →

April 16, 2020 Mustafa EL-Masry #Azure

Sync your local files with Azure Storage Sync Service

We talked before about Storage and the types of storage and how to manage the storage but today we will talk about the file share that’s one of the types of azure storage and the questions now after creating the file share how I can sync my files from my V-Center VM to Azure File share, Microsoft provided us services called Azure file sync so to let us know how we can configure it and what is the prerequisites we should configure it on the V-Center VM

For more information about Azure Storage check below posts and if you need to check all of my azure posts ➡ Latest Microsoft Azure Articles and Posts
Managing and implementing Azure storage
Microsoft Azure Storage Kind and Architecture
Create Storage Account Using PowerShell and CLI Command
How To Monitor Azure Storage Account

Create Azure File Share.
Files Assessment on local V-Center VM.
Install Azure File Sync on Azure.
Install Azure File Sync on local V-Center VM
Registration Verification
Create Cloud Sync endpoint and server endpoint

Sync your local files with Azure Storage Sync Service

Continue reading →

April 15, 2020 Mustafa EL-Masry #Azure, Azure VM

Moving Azure VM Using Recovery Service Vault

As I explained before on my last article [Virtual Machine (VM) Backup and Restore (Vault)] that we can use the Azure recovery services vault for taking backup and doing a restore from azure VM using recovery services vault also the same services can be used to migrate your local VM from V-center to Azure using (Recovery services vault site recovery) and in this post, we will explain how to use this services recovery vault to Move VM between two rejoin and to do failover easily for the VM. Let’s go for technical steps

To know more information about azure services check my (Latest Microsoft Azure Articles and Posts)

How to build replication on VM
How to do Test Failover
How to do Real Failover

Continue reading →

April 15, 2020April 15, 2020 Mustafa EL-Masry #Azure, Azure VM

Virtual Machine (VM) Backup and Restore (Vault)

Introduction

Azure Recovery service vault It is azure built in services doesn’t required any infrastructure preparation and it is supported multiple types of backup (VM , File , Disk and SQL Database) it is one of the built options in the VM , so easily when you open Azure virtual machines and select your VM you will find in the left side Backup from this point and this place you can start to manage your backup and restore process as well you can keep monitoring your backup jobs and restore jobs let us go for demo and how to do VM backup and restore it and what is the restore types supported.

Azure backup Process.
Azure backup hints
How to start to take backup from VM
Azure Recovery Services vault
Azure Restore Options
Azure Restore Hints
How to do VM restore from Azure recovery services vault

To know more information about azure services check my (Latest Microsoft Azure Articles and Posts)

Azure backup Process:

How the backup process will start and what is the sequences that running behind the seances when I asked azure backup services to take backup from my MV.

You need to install Azure backup recovery vault Services
Define backup policy then the backup extension will be installed.
After this the backup services will start to discovery and analysis your VM disks, files, data and size.
Then It will start to create Snapshot from your data. That’s why the backup process sometimes take time but this time will not be more than 24 Hours.
After the snapshot completed the Azure backup extension will transfer the snapshot to azure backup recovery vault.

Azure backup hints

Continue reading →

April 14, 2020April 14, 2020 Mustafa EL-Masry SQl server Administration

Moving Database Files on SQL Server Always On

I think all of us know how to move files for SQL Server databases from disk to another disk but today I will explain how we can do it on SQL Server always on to reduce the downtime and taking new backup to return the database to always-on again. Let us start on the technical steps.

Preparations Steps
Check the current DB Files locations
Check Always on Health Status
Disable all backup jobs on Primary and secondary servers
Suspend the data movement on Secondary server
Remove Database from Primary server
Update DB files by new disk location on secondary server
Stop SQL Server instance on Secondary server
Move (CUT) DB Files from old location to new Location (Past)
Start the SQL Server instance again
Verify the DB File Location Using T-SQL on the post
Join the DB to availability group from Primary server
Check SQL Server always on Health Status Using T-SQL on the post
Enable the SQL Server Jobs\
Failover the SQL Server for Primary (X) to Secondary Server (Y) and do the same steps on (X)