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(256, 12%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
We are planning to migrate our SQL Server dbs to SQL Managed Instance. I was trying to get the Azure Pricing estimate for MI.
Please see attached mi-1.jpg.
THe Azure Pricing Calculator asks for size in GB for PointinTIme Restore. What does this size mean?
We have 10dbs , the combined size of all 10 is around 500gb.
THere is no explanation on this. Please can someone help?
![](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(281.6, 93%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENS%3C/text%3E%3C/svg%3E)
The price is for the storage cost of the back ups depending on which primary location you have your resource in and redundancy you have as described here.
Please let us know if we can help you further.
Regards
Navtej S
Thanks Navetej. The question was more around what Strorage size i should input for PITR in the price calculator. As i said, the combined size of my databases is around 500GB. and i would like a PITR for 14 days.
2 questions:
we are not interested in the LTR for now. Please can suggest for the above 2 items
Thanks
For the first question, it is very difficult to pin point the excess back up storage needed. This document tries to explain this in detail. Please go through the document and let us know if any questions.
Secondly for retention period, please check this document on how you can change the same.
Hope this this answers your questions.
Regards
Navtej S
@Biju Mathew Do let us know if you need further help with this.