This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(156.8, 74%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
All,
Can anyone guide me on how to find out the last restore datetime of a standalone Dedicated SQL Pool? I am looking for a way to obtain this information using either the Azure portal or PowerShell.
Kindly share any resources or insights you might have.
Thank you in advance!
Hey,
Based on my understanding you cannot restore the Restore point as the same database name in same server :
So whenever you want to restore, you would have to create a new pool with different name on same sever and then rename the pools.
Then within properties , you can check the creation date
@KranthiPakala-MSFT : Can you confirm this aspect or is there any other way?
@Nandan Hegde & @Oury Ba-MSFT - Thank you for your help!.
here is the code I used to get CreateDate using PowerShell. Thank you!
$resourceGroupName = "ResourceGroupName"
$sqlServerName = "servername" #without database.window.net
$sqlPool = Get-AzSqlDatabase -ResourceGroupName $resourceGroupName -ServerName $sqlServerName -DatabaseName "DBName"
$sqlPool.CreationDate
@PS Thank you for reaching out.
Please try the below PowerShell Script to get the last restore datetime for an azure dedicated SQL Pool.
I don't see any command to find this.
But from the logs section you can see the activity of the last restore. I just restored one of the DB. The operation name is create or update SQL analytics pools. I restored the DB as demo_restore, you can see that on the restore column.
Hope that helps,
Regards,
Oury
Hey @Oury Ba-MSFT ,
Thank you for this detail.
Can you please confirm whether that data via powershell matches to the creation date that is visible in portal? As restoring means creating a new one itself correct?
You are correct. The date should be creation date only.
Thank you for your contribution on Microsoft Q&A forum.
Regards,
Oury
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more