Forum Discussion
Fabric Cost and Fabric SQL Database backup
PriyaJha :
this gives detailed explanation on analyzing the cost of fabric in Azure Portal step by step
Hi nilendraFabric,
Thanks for your reply.
As per your mentioned path - Azure Portal → Cost Management + Billing Filter by “Service Name = Microsoft.OneLake”, i checked and below is the screenshot-
As per this, only Storage cost is visible then where we can check cost associated with Fabric capacity?
Now, w.r.t backup -
1. Does the fabric SQL database create transaction log files even if there are no transactions involved during that time period?
2. Also, as per your statement, there should be only 1 full backup and as per MSFT you can only restore back uptill 7 days prior. So now my confusion is -
Imagine the full backup got created on 16th June, so the full backup created on 9th June got deleted/overriden. So, in case if i want to restore backup as of 13th June; as the 9th June backup was deleted how would we be able to restore the database to that point in time?
Example--
I have full backup as of 16th June
16th 12 PM full backup
every 12 hrs differential backup
17th 12 AM differential backup
every 10 min logs backup
............. 12:10 AM
............. 12:20 AM
17th 12 PM differential backup
18th 12 AM
If i want to have backup of 18th June 10 AM - i would have to take 16th June full backup, 17th 12 PM differential backups and all 10 mins logs backup uptill 18th 10 AM.
Similarly, if i want to have backup of 13th June 10 AM, how can i get that?
Hi PriyaJha
bottom line is You can only restore to a point in time within the last 7 days, based on the most recent full backup and its associated differentials and logs. Once a full backup and its related backups are deleted (after 7 days), restoration to points before that backup is not possible.
Yes during inactivity top logs will he created
Try "Microsoft Fabric" in the filter for Fabric capacity costing