Category Archives: Azure SQL Server

Backup SQL Server to an Azure Storage Account

One of the benefits of backing up SQL Server to Azure, is an immediate “off site” storage solution. Another, is that Azure storage account can be geo-replicated for additional backup copies. There are a few ways to make this work, … Continue reading

Posted in Azure, Azure SQL Server, SCCM, SQL Server | Leave a comment

Azure Data Migration Service Review

The Data Migration Service (DMS) is a new Azure service still in preview. DMS will help you migrate existing on-premises SQL Server, Oracle, and MySQL databases to Azure SQL Database, Azure SQL Database Managed Instance or SQL Server on an … Continue reading

Posted in Azure SQL Server, Migration, SQL Server 2016 | Leave a comment

SQL Backup to URL (Azure Storage account)

How to backup up a copy of an on premise database, or Azure SQL Server database to an Azure Storage account. Notes: Any names that need to be added at time of creation are indicated with <>, such as <sqlstorageaccountname> … Continue reading

Posted in Azure SQL Server, SQL Server | 4 Comments

Azure SQL Migration Tools

In preparing a presentation for data migration to Azure, thought I’d share some of my research. There are other methods not specified here, but this should be a good start! Each toolset includes notes about that tool, and where to … Continue reading

Posted in Azure SQL Server, Migration, SQL Server | Tagged , | 1 Comment