Giter Club home page Giter Club logo

azure-workload-backup-troubleshooting-scripts's Introduction

Azure Workload Backup Troubleshooting Scripts

This repo maintains troubleshooting scripts for various issues faced during workload backup ( SQL in Azure VM, SAP Hana in Azure VM ) via Azure Recovery Services Vaults.

These scripts can be utilised to root cause the problems faced by customers during times of critical database backups and database restores. Additionally, some of these scripts are can be used for automating operations and simplifying user experience for workload backup.

Key scenarios covered

  • Troubleshooting outbound network connectivity requirements for streaming backup services for SQL and HANA
  • Appropriate permission setting to VM managed identity (system-assigned or user-assigned) for integrating with database consistent snapshots with streaming backup services for SQL and HANA

Contributing

This project welcomes contributions and suggestions. Most contributions require you to agree to a Contributor License Agreement (CLA) declaring that you have the right to, and actually do, grant us the rights to use your contribution. For details, visit https://cla.opensource.microsoft.com.

Please report issues if any script fails to complete its intended purpose. We actively try to fix the bugs and rectify them.

When you submit a pull request, a CLA bot will automatically determine whether you need to provide a CLA and decorate the PR appropriately (e.g., status check, comment). Simply follow the instructions provided by the bot. You will only need to do this once across all repos using our CLA.

This project has adopted the Microsoft Open Source Code of Conduct. For more information see the Code of Conduct FAQ or contact [email protected] with any additional questions or comments.

Trademarks

This project may contain trademarks or logos for projects, products, or services. Authorized use of Microsoft trademarks or logos is subject to and must follow Microsoft's Trademark & Brand Guidelines. Use of Microsoft trademarks or logos in modified versions of this project must not cause confusion or imply Microsoft sponsorship. Any use of third-party trademarks or logos are subject to those third-party's policies.

azure-workload-backup-troubleshooting-scripts's People

Contributors

hiaga avatar jasonbeck2 avatar microsoft-github-operations[bot] avatar microsoftopensource avatar pvrk avatar shashwattrivedi avatar

Stargazers

avatar

Watchers

avatar avatar avatar avatar avatar

Forkers

hiaga shashwattrivedi jasonbeck2 cjpark-sapcsa isabella232 joaotomazio broken2befixed sourcecodecheck

azure-workload-backup-troubleshooting-scripts's Issues

Results not accurate

This tool gives the same output from the working and non working machines and is not relevant for troubleshooting anymore. It used to work previously accurately.
The 'ReportPage.html' file does not get created after the tool is run. Have uploaded below output that comes from both working and non working machines.
image

Connectivity Tests HTTP Proxy Output

When running this script behind a HTTP proxy and with HTTP proxy settings properly configured, I still couldn't succeed on integrating my Azure Windows VM with Azure Backup Service, in order to perform Azure Backup for SQL Server.

As I can understand, the proxy settings need to be configured system-wide, i.e., not only to the logged user but also to the NT Authority\System and NT Service\AzureWLBackupPluginSvc users, used by the Azure Workload Backup Plugin.

On the Get-ProxySettings.ps1, there is a verification on the Windows Registry Key ProxySettingsPerUser on HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows\CurrentVersion\Internet Settings in order to check if proxy configurations are assigned system-wide. According to the script, system-wide configurations (meaning, every user gets the same configs) are enabled when this Registry Key either not exists or is assigned with the 0 value.

Logger "Are Proxy Settings common for all users: $(( $proxyPerUser.GetValue('ProxySettingsPerUser') -eq "0") -or ( $proxyPerUser.GetValue('ProxySettingsPerUser') -eq $null))"

After a few tests, I've only managed to integrate my VM with Azure Backup by explicitly setting the Registry Key to 0, because it doesn't exist by default.

In a nutshell, my question is if the testing script should only confirm system-wide http proxy configurations with the registry key properly set to 0.

Thanks

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.