--- title: "How to manage database backups with the DataMaintenance tool?" slug: "1744038382" tags: ["Backups"] updated: 2026-08-18T08:57:03Z published: 2026-08-18T08:57:03Z canonical: "help.ila.cegid.com/1744038382" stale: true --- > ## Documentation Index > Fetch the complete documentation index at: https://help.ila.cegid.com/llms.txt > Use this file to discover all available pages before exploring further. # How to manage database backups with the DataMaintenance tool? - [x] PT - [ ] ES - [x] AO - [x] CV - [x] MZ - [ ] Professional - [ ] Executive - [ ] Public Sector - [ ] Omnia - [x] Evolution --- The DataMaintenance tool simplifies **database backup management**, allowing operations such as **download**, **restore**, and **data and log control**. --- ## Access To access the Data Maintenance tool, follow these steps: 1. Go to [myCegid](https://mycegid.ila.cegid.com/pt/); 2. Go to the contract; 3. Select the **Service Management** option; 4. Select the Data Maintenance option in the top-right corner. --- ## Downloading Backups You can get backup copies of the companies that exist in the subscription. There are different **types of backups** available: 1. **FULL**: includes a **complete backup** of the databases, performed on **Sunday;** 2. **RECENT**: includes a **complete backup** of the databases, performed **every day except Sunday**; **DIFF Backups** A **DIFF** backup contains the data that was **changed** **since the last complete backup**. Only DIFFs that were **generated immediately** after a **FULL/RECENT** backup can be restored. In the following diagram, you can see that the DIFFs are grouped within their respective FULL/RECENT backups. ![](https://cdn.document360.io/dcab37a5-8229-4a44-bfb1-66adf6fc5367/Images/Documentation/base64-converted-image-1785769604923.png) Here, simply select the desired backup(s) and perform the operation. The process will run, and the files will be made available in the **FTP repository**, in the **/DataMaintenance/Databases/Production/Backups/** folder. The list of backups shown corresponds **to the date the list was last updated**. To make sure the list is up to date, click the **Update Backup List** button. This process may take a few minutes to complete. The backups shown correspond to the **last six months.** > [!WARNING] > You can only select a **maximum of two files** per download. --- ## Restoring Backups You can restore the file(s) submitted via SFTP, in the **/DataMaintenance/Databases/Production/Restores/** folder. If the backup meets the established criteria, the company will be **automatically created in the ERP** during the restore. Otherwise, once the restore process is complete, you must:

  1. Go to Primavera Administrator;

  2. Manually create the company, using the same code present in the backup (for example: PRIXPTO.BAK - company code XPTO);

  3. Fill in the data required for the company.

 **Note**: only backups **with a single version** are supported. The system checks whether a **DIFF is valid** based on the FULL that was submitted. If only a DIFF is submitted, the system validates whether it's compatible with the existing database. You can **submit multiple** FULLs and DIFFs at the same time. If one or more files contain an error, the process is canceled and no *restore* is performed, with the error(s) returned to the log. The company code is required and consists of **four alphanumeric digits.** --- ## Data Control **SFTP Connection** You can view and get the **SFTP access details** for the instance's repository, where you can add or get files for the desired operations. The connection must be made using an **FTP client** that supports **SFTP connections**, such as **FileZilla**. **CheckOut** You can perform an **instant backup of the existing databases**. The process will run, and the generated files will be made available in the **FTP** repository, in the **/DataMaintenance/Operations/Production/CheckOut/PRIXXXXX.bak** folder. Once the operation is complete, the database will go offline. To reactivate it, you must perform a **CheckIn** or **UndoCheckOut**. **Note**: any change to the database requires updating the list of databases, which may take a few minutes to complete. The **file name** and the **database** to be used must be **the same as the current database** you want to replace. **Undo CheckOut** The **Undo Checkout** feature lets you revert a completed **CheckOut** operation, i.e., **bring the existing database back online**. **CheckIn** The **CheckIn** feature lets you **replace a database** that has gone through a **CheckOut** process. This operation **replaces the offline database on the server**, so it will return to its **online state**. To submit the desired file, you must use the **SFTP connection** and place the file(s) in the **/DataMaintenance/Operations/Production/CheckIn/** folder. **Note**: only backups **with a single version** are supported. **Note**: only backups **with a single version** are supported. --- ## Logs The **Logs** page lets you view the **records** and **status of the operations** performed.