Fabric Cost and Fabric SQL Database backup

Hi PriyaJha ,

Thanks for the update.

Fabric capacity SKUs (F2/F4/FT1) are billed under Microsoft Power Platform in Azure Cost Management.

Go to Cost Management + Billing > Filter:
Service Name = Microsoft Power Platform
Or Resource Type = Microsoft.Fabric/capacities

Yes, even if there are no changes, a log backup is still created with a minimal file, to maintain the restore chain.
log backups are created every 10 minutes, even during inactivity. This ensures a continuous restore chain.

Full backups don’t need to be retained beyond 7 days , but restore points within that 7 day window are always guaranteed.
Microsoft uses backup chains internally, which contains:

1 active full backup (within last 7 days)
Differential backups (every 12 hours)
Transaction log backups (every 10 min)

For example: If today is June 17, and a full backup exists from June 16, that full is the base for any restore from June 16 onward.If you want to restore to June 13 @ 10 AM, and you’re within the 7-day retention window:

The June 9 full backup is still retained until June 16, So the restore engine uses:

Full from June 9
Differential from June 13 @ 12 AM
Log backups from 12 AM → 10 AM

After June 16, June 9's full may be discarded, and you’ll no longer be able to restore to June 13.

You can only restore to a point-in-time within the last 7 days, regardless of how many full backups are available.
The backup system manages all files required to make that possible.
So yes, only 1 full backup is retained at a time, but you can restore to any point within the last 7 days, because all required logs and differentials are retained to support that.

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.

Best regards,
Chaithra E.