Get-AzSqlDatabaseRestorePoint Only Returns Earliest Restore Point not All

[GaryRS]

Type of issue

Other (describe below)

Feedback

`Get-AzSqlDatabaseRestorePoint -ResourceGroupName "xxx" -ServerName "xxx" -DatabaseName "xxx"

ResourceGroupName : xxx
ServerName : xxx
DatabaseName : xxx
Location : xxx
RestorePointType : Continuous
RestorePointCreationDate :
EarliestRestoreDate : 5/10/2024 3:58:13 PM
RestorePointLabel `

Page URL

https://learn.microsoft.com/en-us/powershell/module/az.sql/get-azsqldatabaserestorepoint?view=azps-11.6.0&tryIt=true&source=docs#code-try-1

Content source URL

https://github.com/Azure/azure-powershell/blob/main/src/Sql/Sql/help/Get-AzSqlDatabaseRestorePoint.md

Author

@mikefrobbins

Document Id

3027a244-13f3-14da-d4e9-0caa8b20de30

[isra-fel]

Hi Gary can you share the debug log by prepending $DebugPreference = 'Continue' in your script? Do remove any sensitive information.

[GaryRS]

isra-fel, Here's the debug output:

PS C:\Users\XXX> $DebugPreference = 'Continue'
PS C:\Users\XXX> Get-AzSqlDatabaseRestorePoint -ResourceGroupName "XXX" -ServerName "XXX" -DatabaseName "XXX"

DEBUG: 1:06:23 PM - [ConfigManager] Got nothing from [DisplaySecretsWarning], Module = [], Cmdlet = []. Returning default value [True].
DEBUG: 1:06:23 PM - GetAzureSqlDatabaseRestorePoint begin processing with ParameterSet '__AllParameterSets'.
DEBUG: 1:06:23 PM - using account id 'xxx'...
DEBUG: 1:06:23 PM - [ConfigManager] Got nothing from [DisplayBreakingChangeWarning], Module = [], Cmdlet = []. Returning default value [True].
DEBUG: [Common.Authentication]: Authenticating using Account: 'XXX', environment: 'AzureCloud', tenant: '3edd1b0e-deb5-4d7f-940d-95a2d073565f'
DEBUG: 1:06:23 PM - [ConfigManager] Got nothing from [DisableInstanceDiscovery], Module = [], Cmdlet = []. Returning default value [False].
DEBUG: 1:06:23 PM - [ConfigManager] Got nothing from [EnableLoginByWam], Module = [], Cmdlet = []. Returning default value [True].
DEBUG: 1:06:23 PM - [SilentAuthenticator] Calling SharedTokenCacheCredential.GetTokenAsync - TenantId:'XXX', Scopes:'https://management.core.windows.net//.default', AuthorityHost:'https://login.microsoftonline.com/', UserId:'XXX'
DEBUG: SharedTokenCacheCredential.GetToken invoked. Scopes: [ https://management.core.windows.net//.default ] ParentRequestId:
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z - adceaa8e-1e14-4aeb-bf96-ad3b1e33597c] IsLegacyAdalCacheEnabled: yes
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z - adceaa8e-1e14-4aeb-bf96-ad3b1e33597c] [Region discovery] Not using a regional authority.
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z - adceaa8e-1e14-4aeb-bf96-ad3b1e33597c] [Region discovery] Not using a regional authority.
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z - adceaa8e-1e14-4aeb-bf96-ad3b1e33597c] IsLegacyAdalCacheEnabled: yes
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z - adceaa8e-1e14-4aeb-bf96-ad3b1e33597c] IsLegacyAdalCacheEnabled: yes
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z] [Runtime] WAM supported OS.
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z] [RuntimeBroker] ListWindowsWorkAndSchoolAccounts option was not enabled.
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z - 97c210fd-5ab3-46f9-b5ad-de67e87b7281] [Region discovery] Not using a regional authority.
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z] Found 1 cache accounts and 0 broker accounts
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z] Returning 1 accounts
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z - b8c1c650-1cd1-441d-97f7-da840f113c0a] MSAL MSAL.CoreCLR with assembly version '4.60.3.0'. CorrelationId(b8c1c650-1cd1-441d-97f7-da840f113c0a)
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z - b8c1c650-1cd1-441d-97f7-da840f113c0a] === AcquireTokenSilent Parameters ===
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z - b8c1c650-1cd1-441d-97f7-da840f113c0a] LoginHint provided: False
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z - b8c1c650-1cd1-441d-97f7-da840f113c0a] Account provided: True
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z - b8c1c650-1cd1-441d-97f7-da840f113c0a] ForceRefresh: False
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z - b8c1c650-1cd1-441d-97f7-da840f113c0a]
=== Request Data ===
Authority Provided? - True
Scopes - https://management.core.windows.net//.default
Extra Query Params Keys (space separated) -
ApiId - AcquireTokenSilent
IsConfidentialClient - False
SendX5C - False
LoginHint ? False
IsBrokerConfigured - True
HomeAccountId - False
CorrelationId - b8c1c650-1cd1-441d-97f7-da840f113c0a
UserAssertion set: False
LongRunningOboCacheKey set: False
Region configured:

DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z - b8c1c650-1cd1-441d-97f7-da840f113c0a] === Token Acquisition (SilentRequest) started:
Scopes: https://management.core.windows.net//.default
Authority Host: login.microsoftonline.com
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z - b8c1c650-1cd1-441d-97f7-da840f113c0a] Broker is configured and enabled, attempting to use broker instead.
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z] [Runtime] WAM supported OS.
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z - b8c1c650-1cd1-441d-97f7-da840f113c0a] Can invoke broker. Will attempt to acquire token with broker.
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z] [MSAL:0001] WARNING SetAuthorityString:98 Initializing authority from string 'https://login.microsoftonline.com/3edd1b0e-deb5-4d7f-940d-95a2d073565f/' without authority type, defaulting to MsSts
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z] [MSAL:0005] INFO LogTelemetryData:393 Printing Telemetry for Correlation ID: b8c1c650-1cd1-441d-97f7-da840f113c0a
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z] [MSAL:0005] INFO LogTelemetryData:401 Key: start_time, Value: 2024-05-27T17:06:23.000Z
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z] [MSAL:0005] INFO LogTelemetryData:401 Key: api_name, Value: ReadAccountById
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z] [MSAL:0005] INFO LogTelemetryData:401 Key: was_request_throttled, Value: false
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z] [MSAL:0005] INFO LogTelemetryData:401 Key: authority_type, Value: Unknown
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z] [MSAL:0005] INFO LogTelemetryData:401 Key: msal_version, Value: 1.1.0+local
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z] [MSAL:0005] INFO LogTelemetryData:401 Key: correlation_id, Value: b8c1c650-1cd1-441d-97f7-da840f113c0a
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z] [MSAL:0005] INFO LogTelemetryData:401 Key: broker_app_used, Value: false
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z] [MSAL:0005] INFO LogTelemetryData:401 Key: stop_time, Value: 2024-05-27T17:06:23.000Z
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z] [MSAL:0005] INFO LogTelemetryData:401 Key: msalruntime_version, Value: 0.16.0
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z] [MSAL:0005] INFO LogTelemetryData:401 Key: is_successful, Value: true
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z] [MSAL:0005] INFO LogTelemetryData:401 Key: request_duration, Value: 0
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z] [MSAL:0005] INFO SetCorrelationId:273 Set correlation ID: b8c1c650-1cd1-441d-97f7-da840f113c0a
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z] [MSAL:0005] INFO EnqueueBackgroundRequest:952 The original authority is 'https://login.microsoftonline.com/3edd1b0e-deb5-4d7f-940d-95a2d073565f'
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z] [MSAL:0005] INFO ModifyAndValidateAuthParameters:191 Additional query parameter added successfully. Key: '(pii)' Value: '(pii)'
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z] [MSAL:0005] INFO ModifyAndValidateAuthParameters:215 Authority Realm: 3edd1b0e-deb5-4d7f-940d-95a2d073565f
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z] [MSAL:0003] INFO StorageTokenResponse:84 StorageTokenResponse account constructor invoked. This is only expected in Runtime flows
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z] [MSAL:0003] INFO LogTelemetryData:393 Printing Telemetry for Correlation ID: b8c1c650-1cd1-441d-97f7-da840f113c0a
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z] [MSAL:0003] INFO LogTelemetryData:401 Key: start_time, Value: 2024-05-27T17:06:23.000Z
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z] [MSAL:0003] INFO LogTelemetryData:401 Key: api_name, Value: AcquireTokenSilently
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z] [MSAL:0003] INFO LogTelemetryData:401 Key: was_request_throttled, Value: false
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z] [MSAL:0003] INFO LogTelemetryData:401 Key: authority_type, Value: MSA
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z] [MSAL:0003] INFO LogTelemetryData:401 Key: access_token_expiry_time, Value: 2024-05-27T18:21:30.000Z
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z] [MSAL:0003] INFO LogTelemetryData:401 Key: read_token, Value: ID|AT
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z] [MSAL:0003] INFO LogTelemetryData:401 Key: msal_version, Value: 1.1.0+local
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z] [MSAL:0003] INFO LogTelemetryData:401 Key: client_id, Value: 1950a258-227b-4e31-a9cf-717495945fc2
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z] [MSAL:0003] INFO LogTelemetryData:401 Key: correlation_id, Value: b8c1c650-1cd1-441d-97f7-da840f113c0a
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z] [MSAL:0003] INFO LogTelemetryData:401 Key: broker_app_used, Value: false
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z] [MSAL:0003] INFO LogTelemetryData:401 Key: stop_time, Value: 2024-05-27T17:06:23.000Z
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z] [MSAL:0003] INFO LogTelemetryData:401 Key: msalruntime_version, Value: 0.16.0
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z] [MSAL:0003] INFO LogTelemetryData:401 Key: original_authority, Value: https://login.microsoftonline.com/3edd1b0e-deb5-4d7f-940d-95a2d073565f
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z] [MSAL:0003] INFO LogTelemetryData:401 Key: additional_query_parameters_count, Value: 1
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z] [MSAL:0003] INFO LogTelemetryData:401 Key: storage_read, Value: DAC|DAT|DID
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z] [MSAL:0003] INFO LogTelemetryData:401 Key: auth_flow, Value: AT
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z] [MSAL:0003] INFO LogTelemetryData:401 Key: is_successful, Value: true
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z] [MSAL:0003] INFO LogTelemetryData:401 Key: authorization_type, Value: WindowsIntegratedAuth
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z] [MSAL:0003] INFO LogTelemetryData:401 Key: request_duration, Value: 3
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z] [MSAL:0003] INFO LogTelemetryData:406 Printing Execution Flow:
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z] [MSAL:0003] INFO LogTelemetryData:414 {"t":"4s7uc","tid":5,"ts":0,"l":2},{"t":"4sufd","tid":5,"ts":0,"s":2,"l":2},{"t":"4swgg","tid":5,"ts":0,"s":3,"l":2},{"t":"4swgf","tid":5,"ts":0,"s":1,"l":2},{"t":"4swgi","tid":3,"ts":0,"s":3,"l":2},{"t":"8b2yn","tid":3,"ts":0,"l":2},{"t":"8dqkx","tid":3,"ts":0,"l":2},{"t":"8dqik","tid":3,"ts":0,"l":2},{"t":"4q2di","tid":3,"ts":0,"l":2},{"t":"4qnng","tid":3,"ts":0,"l":2,"a":2,"ie":0},{"t":"4qnnf","tid":3,"ts":1,"l":2,"a":2,"ie":1},{"t":"8dqit","tid":3,"ts":1,"l":2},{"t":"8b2ht","tid":3,"ts":1,"l":2},{"t":"4qnno","tid":3,"ts":1,"l":2,"a":2,"ie":0},{"t":"4qnnn","tid":3,"ts":3,"l":2,"a":2,"ie":1},{"t":"6xuag","tid":3,"ts":3,"l":2}
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z] [RuntimeBroker] WAM response status success
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z - b8c1c650-1cd1-441d-97f7-da840f113c0a] Checking MsalTokenResponse returned from broker.
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z - b8c1c650-1cd1-441d-97f7-da840f113c0a] Success. Response contains an access token.
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z - b8c1c650-1cd1-441d-97f7-da840f113c0a] Checking client info returned from the server..
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z - b8c1c650-1cd1-441d-97f7-da840f113c0a] Saving token response to cache..
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z - b8c1c650-1cd1-441d-97f7-da840f113c0a] [Instance Discovery] Instance discovery is enabled and will be performed
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z - b8c1c650-1cd1-441d-97f7-da840f113c0a] [Region discovery] Not using a regional authority.
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z - b8c1c650-1cd1-441d-97f7-da840f113c0a] [Region discovery] Not using a regional authority.
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z - b8c1c650-1cd1-441d-97f7-da840f113c0a] [SaveTokenResponseAsync] Saving Id Token and Account in cache ...
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z - b8c1c650-1cd1-441d-97f7-da840f113c0a]
=== Token Acquisition finished successfully:
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z - b8c1c650-1cd1-441d-97f7-da840f113c0a] AT expiration time: 5/27/2024 6:21:29 PM +00:00, scopes: https://management.core.windows.net//.default https://management.core.windows.net//user_impersonation. source: Broker
DEBUG: False MSAL 4.60.3.0 MSAL.CoreCLR .NET 8.0.4 Microsoft Windows 10.0.22621 [2024-05-27 17:06:23Z - b8c1c650-1cd1-441d-97f7-da840f113c0a] Fetched access token from host login.microsoftonline.com.
DEBUG: SharedTokenCacheCredential.GetToken succeeded. Scopes: [ https://management.core.windows.net//.default ] ParentRequestId: ExpiresOn: 2024-05-27T18:21:29.6392815+00:00
DEBUG: [Common.Authentication]: Received token with LoginType 'User', Tenant: 'XXX', UserId: 'XXX'
DEBUG: ============================ HTTP REQUEST ============================

HTTP Method:
GET

Absolute Uri:
https://management.azure.com/subscriptions/XXX/resourceGroups/xxx/providers/Microsoft.Sql/servers/xxx/restorePoints?api-version=2020-11-01-preview

Headers:
Accept-Language : en-US
x-ms-client-request-id : 2b02b7bc-089a-4c82-94bc-dee563ef82c7

Body:

DEBUG: ============================ HTTP RESPONSE ============================

Status Code:
OK

Headers:
Cache-Control : no-cache
Pragma : no-cache
x-ms-request-id : db0f3c08-35e3-4b84-83eb-cfec573484b6
x-ms-throttling-version : v1
x-ms-ratelimit-remaining-subscription-reads: 11999
x-ms-correlation-request-id : 2fba7813-a335-4bc7-a059-d0450bb7e610
x-ms-routing-request-id : EASTUS:20240527T170625Z:2fba7813-a335-4bc7-a059-d0450bb7e610
Strict-Transport-Security : max-age=31536000; includeSubDomains
X-Content-Type-Options : nosniff
X-Cache : CONFIG_NOCACHE
X-MSEdge-Ref : Ref A: 94A9BF694AB1467C90A7E980F4D452C9 Ref B: BN1AA2051013021 Ref C: 2024-05-27T17:06:25Z
Date : Mon, 27 May 2024 17:06:24 GMT

Body:
{
"value": [
{
"location": "East US 2",
"properties": {
"restorePointType": "CONTINUOUS",
"earliestRestoreDate": "2024-05-21T17:06:25.1914544Z"
},
"id": "/subscriptions/56708b40-1dc8-4f0b-b5eb-5678a55e500a/resourceGroups/altastareast3/providers/Microsoft.Sql/servers/XXX/restorePoints/ContinuousRestorePoint",
"name": "ContinuousRestorePoint",
"type": "Microsoft.Sql/servers/databases/restorePoints"
}
]
}

DEBUG: 1:06:25 PM - [ConfigManager] Got nothing from [DisplaySecretsWarning], Module = [], Cmdlet = []. Returning default value [True].

ResourceGroupName : XXX
ServerName : XXX
DatabaseName : XXX
Location : East US 2
RestorePointType : Continuous
RestorePointCreationDate :
EarliestRestoreDate : 5/21/2024 5:06:25 PM
RestorePointLabel :

DEBUG: 1:06:25 PM - [ConfigManager] Got nothing from [DisplayRegionIdentified], Module = [], Cmdlet = []. Returning default value [True].
DEBUG: 1:06:25 PM - [ConfigManager] Got nothing from [CheckForUpgrade], Module = [], Cmdlet = []. Returning default value [True].
DEBUG: AzureQoSEvent: Module: Az.Sql:5.0.0; CommandName: Get-AzSqlDatabaseRestorePoint; PSVersion: 7.4.2; IsSuccess: True; Duration: 00:00:01.4350842; SanitizeDuration: 00:00:00.0002948
DEBUG: 1:06:25 PM - [ConfigManager] Got nothing from [EnableDataCollection], Module = [], Cmdlet = []. Returning default value [True].
DEBUG: 1:06:25 PM - GetAzureSqlDatabaseRestorePoint end processing.