search

MicrosoftDocs / azure-docs

Open source documentation of Microsoft Azure
https://docs.microsoft.com/azure
Creative Commons Attribution 4.0 International
10.25k stars 21.42k forks source link

Create Restore Point Powershell command (New-AzSqlDatabaseRestorePoint) does not support for Azure Synapse Dedicated SQL Pool #108804

Closed tmfahim closed 1 year ago

tmfahim commented 1 year ago

Create Restore Point Powershell command (New-AzSqlDatabaseRestorePoint) does not support for Azure Synapse Analytics as the server URL is different for Synapse Dedicated SQL Pool versus Azure SQL DB. I request to add support for Synapse DSP or update the documentation if it is already supported.

$ServerName="" # Without database.windows.net [Enter feedback here]

Document Details

⚠ Do not edit this section. It is required for learn.microsoft.com ➟ GitHub issue linking.

Naveenommi-MSFT commented 1 year ago

@tmfahim Thanks for your feedback! We will investigate and update as appropriate.

RamanathanChinnappan-MSFT commented 1 year ago

@tmfahim

You are correct that the New-AzSqlDatabaseRestorePoint command does not currently support Azure Synapse Analytics. The command is designed to work with Azure SQL Database, which has a different server URL than Synapse Dedicated SQL Pool.

At this time, there is no information available on whether this command will be updated to support Synapse Dedicated SQL Pool. However, you can use the New-AzSynapseSqlRestorePoint command to create a restore point for Synapse Dedicated SQL Pool.

Here is an example of how to use the New-AzSynapseSqlRestorePoint command:

New-AzSynapseSqlRestorePoint -WorkspaceName "myworkspace" -SqlPoolName "mypool" -RestorePointLabel "mylabel"

This command creates a restore point with the label "mylabel" for the Synapse Dedicated SQL Pool "mypool" in the workspace "myworkspace".

I hope this helps! Let me know if you have any further questions.

tmfahim commented 1 year ago

Thanks for the information. As there is no option to provide credential as parameter, does it need to login into Azure first if this action will be performed using a Powershell script?

Thanks for your answer.

With Regards,

Fahim Amin Data Architect, Heavy Oil Upstream Digital Accelerator Ph.: +1-587-476-2540 Cell: +1-403-860-1124 @.**@.>

ExxonMobil Business Support Centre Canada ULC 505 Quarry Park Blvd. SE Central Building- C2A.126 Calgary AB T2C 5N1

From: RamanathanChinnappan @.> Sent: Thursday, April 27, 2023 4:17 AM To: MicrosoftDocs/azure-docs @.> Cc: Amin, Fahim @.>; Mention @.> Subject: Re: [MicrosoftDocs/azure-docs] Create Restore Point Powershell command (New-AzSqlDatabaseRestorePoint) does not support for Azure Synapse Dedicated SQL Pool (Issue #108804)

External Email - Think Before You Click

@tmfahimhttps://github.com/tmfahim

You are correct that the New-AzSqlDatabaseRestorePoint command does not currently support Azure Synapse Analytics. The command is designed to work with Azure SQL Database, which has a different server URL than Synapse Dedicated SQL Pool.

At this time, there is no information available on whether this command will be updated to support Synapse Dedicated SQL Pool. However, you can use the New-AzSynapseSqlRestorePoint command to create a restore point for Synapse Dedicated SQL Pool.

Here is an example of how to use the New-AzSynapseSqlRestorePoint command:

New-AzSynapseSqlRestorePoint -WorkspaceName "myworkspace" -SqlPoolName "mypool" -RestorePointLabel "mylabel"

This command creates a restore point with the label "mylabel" for the Synapse Dedicated SQL Pool "mypool" in the workspace "myworkspace".

I hope this helps! Let me know if you have any further questions.

— Reply to this email directly, view it on GitHubhttps://github.com/MicrosoftDocs/azure-docs/issues/108804#issuecomment-1525380906, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AYLTXYANK656SXIAXUKHFNLXDJBTTANCNFSM6AAAAAAXNAUFNI. You are receiving this because you were mentioned.Message ID: @.**@.>>

RamanathanChinnappan-MSFT commented 1 year ago

@tmfahim

Yes, you need to authenticate to Azure before running any PowerShell script that interacts with Azure resources. You can use the Connect-AzAccount cmdlet to authenticate to Azure with your credentials. Once authenticated, you can run your script to perform the desired actions on Azure resources.

If there are any further questions regarding the documentation, please tag me in your reply and we will be happy to continue the conversation.

RamanathanChinnappan-MSFT commented 1 year ago

@tmfahim

We are going to close this thread, if there are any further questions regarding the documentation, please tag me in your reply and we will be happy to continue the conversation.