Database Point-in-time restore

(0) Share

Report

Posted on by Yuji

4,131

Hi,

If I would like to request a point-in-time restore for my config environment, how often the DB backup was taken, can we request a backup only an hour earlier?

Thanks,

I have the same question (0)

All responses (12)

Answers (2)

Verified answer

Mea_ 60,284 on at

Like (0)

Report

Each 15 minutes for 30 days. So for example, you can restore to a backup taken at 6.00, 6.15, 6.30 and 6.45

Was this reply helpful? Yes No
Yuji 4,131 on at

Like (0)

Report

What is the lead time for point-in-time restore? A couple of hours?

Was this reply helpful? Yes No
Verified answer

Sukrut Parab 71,710 Moderator on at

Like (0)

Report

It depends on your db size. For a size of 300 gb database it completes between in 2-5hours.

Was this reply helpful? Yes No
Yuji 4,131 on at

Like (0)

Report

Is the article still valid?

docs.microsoft.com/.../submit-request-dynamics-service-engineering-team

It mentioned Five hour lead time and Five hours downtime for Point-in-time restore.

Was this reply helpful? Yes No
Suggested answer

Satish Panwar 14,671 Moderator on at

Like (0)

Report

Hi Yuji,

Just heard the same numbers from MS team last week as mentioned in thread above 5 + 5 hours.

Was this reply helpful? Yes No
Yuji 4,131 on at

Like (0)

Report

Is every 15 minutes snapshot configurable? To change it to every 10 minutes.

Was this reply helpful? Yes No
Suggested answer

Sukrut Parab 71,710 Moderator on at

Like (0)

Report

You can not , if you try to do point in time restore less than 15 mins you get error.

Was this reply helpful? Yes No
Yuji 4,131 on at

Like (0)

Report

If I did a point-in-time restore back to four days earlier, can I restore the point-in-time to today again?

Was this reply helpful? Yes No
Yuji 4,131 on at

Like (0)

Report

What does the statement means below? If I restored to 17 Jan 2020 8AM, I could not restore to the same time again? But I can still restore to 17 Jan 2020 8:15AM?

"Point-in-time restore breaks the chain of available restore points

The restore database process always creates a new database based on a previous point-in-time snapshot. Because of this, the new database does not have any restore history, but does begin to accrue new restore points going forward. This means that after performing point-in-time restore you will not be able to do so again using the same restore date and time."

Was this reply helpful? Yes No
Suggested answer

Sukrut Parab 71,710 Moderator on at

Like (0)

Report

If you have done restore at 17 Jan at 8 AM , why would you do same restore on same environment again ? Anyways you can not do another one on the same environment until first one finishes. After first one finishes , you can do another one by selecting any time after 8.15 .

Suppose you restore finishes at 1 PM . on 17th Jan , you cna again start another restore on same environment with any time on or before 12.45 PM.

Was this reply helpful? Yes No