# Managing `TiDB` Database: On-Premised Versus `TiDB Cloud`


| Operation type | On-premises database | Cloud database | 
| :------------- | :------------------- | :------------- | 
| Database  backup | Local storage or cloud | `TiDB Cloud` Service container / Local storage /  Both Cloud Storage and Local / Storage |
| Scheduling of database backups | Manual scheduling using `br cli` | Automatic or Manual Scheduling:`br cli` |
| Location for database files and backups | Manual |Automatic | 
| Database recovery | Manual using `br cli` for recovery | Automated using Database Service console or `br cli` | 
| Patch compliance | None,`TiDB` Support | `GUI` Tool | 
| Housekeeping of database logs and diagnostics files | Manual | Automatic | 

---------------------------------------------------------------------------
The table in the slide lists the main differences(based on type of `DBA` operations) between on-premises databases and cloud database deployments.