Performing Backups & Restores (part 2 of 3)

By Ashwin Venugopal -

 



To read part 1 please click here
To read part 3 please click here


SQL Server Backups

SQL Server backup to URL (Azure Storage)

If you want to implement SQL Server Backup to URL, then, you have to use the following methods:
  • Back Up Task in SQL Server Management Studio- A database can be backed up to URL via the Back Up task in SQL Server Management Studio using an SQL Server Credential.

  • SQL Server Backup to URL Using Maintenance Plan Wizard- The Maintenance Plan Wizard in SQL Server Management Studio includes URL as one of the destination options, and the other supporting objects required to backup to Windows Azure storage like the SQL Credential.

  • Transact-SQL , PowerShell or C#- These options should create a striped backup set, an SQL Server file-snapshot backup, or an SQL credential using Shared Access token.

SQL Server Automated Backup v2 for Azure VMs

The Managed Backup can be automatically configured by Automated Backup v2 to Microsoft Azure for all existing and new databases on an Azure VM running SQL Server 2016/2017 Standard, Enterprise, or Developer editions which allows you to configure regular database backups utilizing Azure blob storage.

Automated Backup v2 can easily work with SQL Server 2016 or higher while Automated Backup v1 can be used to back up your databases for SQL Server 2014.

Database Configuration:

  • The full recovery model can be easily used by Target databases.
  • It is unnecessary to use full recovery model by System databases, but while using log backups for Model or MSDB you have to use full recovery model.
  • Target databases must be on either the default SQL Server instance, or a named instance installed by the procedure described at https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-sql-server-iaas-faq#administration   

To configure Automated Backup v2, the Azure portal or Az PowerShell can also be used during provisioning or existing SQL Server 2016/2017 VMs.

SQL Server Backup in Azure VMs (to Recovery Services Vault)

This process includes running discovery of SQL Server instances and their databases from an Azure Recovery Services vault, selecting the databases to be backed up in the discovery results as well as assigning a backup policy that determines backup settings, like frequency and retention. If the SQL Server VM isn't created with the help of Azure Marketplace image, then, you should assign the sysadmin role to NT SERVICE\AzureWLBackupPluginSvc account.

SQL Server file snapshot-based backups to Azure Storage

Azure snapshots can be used by SQL Server File-snapshot backup to provide almost instantaneous backups and quicker restores for database files stored using the Azure Blob storage service which allows you to simplify your backup as well as restore policies.

Azure PowerShell scripts and SQL queries can be used to apply SQL Server data files as Azure Blobs which will also readily help you to create a database in SQL Server running on-premises or in a VM on Azure as well as setting up dedicated storage location for your data  in Azure blob Storage. 

Whatever implementation method you use, this process involves setting up a storage account, creating SQL Server credentials as well as creating a database files stored in blobs. SQL server also requires the credentials to store the security information which can be used to write and read from the Azure blob container.  






To read part 1 please click here
To read part 3 please click here











Comments

Post a Comment

Popular posts from this blog

Query, Visualize, & Monitor Data in Azure Sentinel

By Ashwin Venugopal -
Image
  Azure Sentinel Workbooks Several ready for use templates are provided by the Azure Sentinel that can be used to create your own workbook and then modify them as needed for Contoso. Most of the data connectors it uses to ingest data come with their own workbooks, but better insight can be obtained by simply looking into the data that is being ingested by using tables and visualizations, including bar and pie charts. You can also make your own workbook easily by using this data from the beginning instead of using the predefined templates. Workbook Page You can easily access the workbook page from the Azure Sentinel from the navigation pane which consists of the: Workbook header- You can add a new workbook and review the saved workbooks as well as templates that are available on the workbook page. Templates section- You can access existing workbook templates on the Templates tab. You can save some of the workbooks for quick access and they will appear on the My Workbooks tab.  From the
Read more

Planning for Implementing SAP Solutions on Azure (Part 2 of 5)

By Ashwin Venugopal -
Image
  To read part 1 please click  here To read part 3 please click  here To read part 4 please click  here To read part 5 please click  here Load Balancing The load balancer uses probe ports to determine as well as route the traffic to an active DBMS node, but of there's any failover then the most common SAP application architecture can automatically reconnect against the private virtual IP address without the need for the SAP application to reconfigure it, while the load balancer redirect the traffic against the private virtual IP address without any need for the SAP application to reconfigure. The loaf balancer also offers an option of DirectServerReturn which if configured, can help in directing the traffic from the DBMS VM to the SAP application layer directly to the application layer without routing through the load balancer. But, if it isn't configured, then the return traffic to the SAP application layer is routed through the load balancer. You can also use Azure Load Balan
Read more

Work with String Data Using KQL Statements

By Ashwin Venugopal -
Image
  Extract Data from Unstructured String Fields Unstructured string fields often contains the Security log data and requires parsing to extract data. There are multiple ways of pulling information from string fields in KQL and the two primary operators used are extract and parse.  Extract It gets a match for a regular expression from a text string. You can convert the extracted substring to the indicated type.  Arguments regex- A regular expression. captureGroup- A positive int constant indicating the capture group to extract. 0 stands for the entire match, 1 for the value matched by the first '('parenthesis')' in the regular expression, 2 or more for subsequent parenthesis.  text- A string to search. typeLiteral- An optional type literal. If provided, the extracted substring is converted to this type.  Returns If regex finds a match in text- the substring matched against the indicated capture group captureGroup, optionally converted to typeLiteral. If there's no mat
Read more