Share via

Azure SQL database restore database point in time recovery

Ashwan 536 Reputation points
2022-06-23T01:58:13.417+00:00

Hi We have Azure SQL Databases and setup default backup retention . We are looking to restore the backup lasted backup . how ever time is different to our local time . cound you please let me know how to adjust to timing to our local in Azure. this time shows 8 hours behind our time
214132-restoredb.jpg

Azure SQL Database
0 comments
Answer accepted by question author
  1. Alberto Morillo 35,401 Reputation points MVP Volunteer Moderator
    2022-06-24T02:35:29.123+00:00

    Here my local time is 4 hours less than UTC time, my time is -4 GMT, so when I see below image:

    214611-image.png

    I am restoring to the point 10:23 pm on June 22 (time zone -4 GMT) instead of restoring to 2:23 am UTC time on June 23. I always have to substract 4 hours since -4 GMT is my time zone. It is a simple way to translate to local time.

    Unfortunately you will have to explain people that Microsoft Data Centers rely on UTC time to keep their operations in sync and allow many features that offer cross region tasks. It is not that difficult to explain how to add/substract hours depending on the time zone of the users.

    0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Alberto Morillo 35,401 Reputation points MVP Volunteer Moderator
    2022-06-23T15:13:32.127+00:00

    You cannot adjust this screen to your local time. You will have to convert the desired local restore time to a UTC time you can provide as input on this screen.

    The restore point is also a little confusing: the monitoring graphs are in local time, the oldest restore time is in 24H UTC time (Greenwich), and the restore point time entry form is in 12H UTC time.

    0 comments
  2. Ashwan 536 Reputation points
    2022-06-24T02:13:38.47+00:00

    Hi @Alberto Morillo thank you for the update.

    lets say our time 12.07Pm 06/24/2022, then restore time shows 2.07am 06/24/2022 (nearly 10 hours different ) is max latest allow us to restore window. if any issues happened in our time say 8.00am then do we have to calculated back then restore time should be 10.00pm 06/23/2022? really confusing this. and we cant give people screen shot evidence that we did correctly with timing. in our case business will say we lost so may data due to big time gaps .. what we do for that please

    regards

    0 comments
  3. Ashwan 536 Reputation points
    2022-06-24T07:31:00.97+00:00

    Hi AlbertoMorillo is that only for Azure SQL database or same on other services like SQL Virtual machine, managed instances ? or all Azure services ?

    thanks

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.