How to Automate exporting of Azure SQL Database to blog storage

Поделиться
HTML-код
  • Опубликовано: 2 фев 2025

Комментарии • 23

  • @sivas842
    @sivas842 3 года назад

    Thank you for sharing the most useful video. It's very helpful for us and we are expecting more from you and we totally appreciate your talent.

  • @swapnilsonawane2525
    @swapnilsonawane2525 8 месяцев назад

    can we get this new process of Azure for same step ?? many features used in video are actully degraded now.

    • @MSSQLDBATechSupport
      @MSSQLDBATechSupport  8 месяцев назад

      yup... This is very old video and as you said some options might be degraded... however they might other alternatives available. that we need to explore.Once free time is available i can do some R&D on this.

  • @adhargupta3441
    @adhargupta3441 Год назад +1

    Don't know why Iam getting this error "the running commamd stopped because the preferemce variable " Error action preference" Or common paramtere is set to stop:the remote server returned an error. Http status code :403-HTTP ERROR MESSAGE. THIS request is not authorised to perform this operation.।।।।।।
    Plz sir help me 😭😭

    • @adhargupta3441
      @adhargupta3441 Год назад

      In storage accounts networking I added my ip still the same error and also in my case db is postgres😢

    • @MSSQLDBATechSupport
      @MSSQLDBATechSupport  Год назад

      I had tested this for Azure MS SQL DATABASE not for Postgress. I need to test it before to comment if any

  • @yaseenafzal6162
    @yaseenafzal6162 10 месяцев назад

    i am facing this error The running command stopped because the preference variable "ErrorActionPreference" or common parameter is set to Stop: 'this.Client.SubscriptionId' cannot be null.

    • @MSSQLDBATechSupport
      @MSSQLDBATechSupport  10 месяцев назад

      The error message you're encountering seems to be related to a script or command that is trying to access the SubscriptionId property of a client object, but it's encountering a situation where this property is null, causing the script or command to halt.
      To address this issue, you need to ensure that the SubscriptionId property is properly set before attempting to access it.

  • @bhargavb8617
    @bhargavb8617 7 месяцев назад

    can we export 1.5 TB of azure sql database to blob storage? DB tier is serverless.
    Please let me know

    • @MSSQLDBATechSupport
      @MSSQLDBATechSupport  7 месяцев назад

      As of i know its not possible however azure will introduce new changes when compared to onprem sql server. its better to test it once or reach microsoft support for more info

    • @bhargavb8617
      @bhargavb8617 6 месяцев назад

      @@MSSQLDBATechSupport Thanks for the confirmation

    • @MSSQLDBATechSupport
      @MSSQLDBATechSupport  6 месяцев назад

      welcome

  • @jibyvarghese8758
    @jibyvarghese8758 2 года назад

    I downloaded your file and tried to backup sql to blob. But i am getting below error. Can you please help?
    New-AzureStorageContext:
    Line |
    89 | $StorageContext = New-AzureStorageContext -StorageAccountName $storag
    | ~~~~~~~~~~~~~~~~~~~~~~~| The term 'New-AzureStorageContext' is not recognized as a name of a
    cmdlet, function, script file, or executable program. Check the spelling
    of the name, or if a path was included, verify that the path is correct
    and try again.

    • @MSSQLDBATechSupport
      @MSSQLDBATechSupport  2 года назад

      Based on error:it seems link you are having AZ old module,
      Please do upgrade the AZ module and try again,
      Thanks
      MS SQL DBA Tech Support

    • @shrinivaskulkarni3788
      @shrinivaskulkarni3788 Год назад

      @@MSSQLDBATechSupport after updating AZ module also i am getting same error

    • @MSSQLDBATechSupport
      @MSSQLDBATechSupport  Год назад

      For azure there will be always updates happen.. so they are some cases where existing functionality can broken. Please raise ticket to Microsoft ,so that they have all the tools to debug and fix the issues.

    • @iubaidmabrook
      @iubaidmabrook 11 месяцев назад

      @@shrinivaskulkarni3788 use New-AzStorageContext

    • @MSSQLDBATechSupport
      @MSSQLDBATechSupport  11 месяцев назад

      😊

  • @bhargavg2021
    @bhargavg2021 3 года назад

    Thank you so much for the video bro..