Unable to restore database : zip file too large

Unable to restore database : zip file too large

In oldest versions like 8.0, 8.1. 8.2, 8.3, you may come across restore issues when the backup file is huge (even more than 3 or 4GB). In those cases, this article would be helpful.

Scenario 1:

If you come across this when you are trying to setup UAT environment, then the solution to this would be, to take trimmed backup from PROD server and then try to restore the same in UAT setup. This will have the restore successful. Later you can copy the following folder from PROD to UAT,

Custom, Images, Inline Images and File Attachments under ManageEngine\Servicedesk Plus MSP folder.

Scenario 2:

There may be certain cases say where you do not have UAT and after upgrade failure in PROD, you do not have a trimmed backup or a SQL backup or VM snapshot, but ONLY a full backup which gives you the error mentioned in subject, then, in those cases, you are left with only option i.e. to restore the full backup to get your PROD server up and running. Please refer steps to achieve the same after removing the File Attachments and Inline images which consists of more data.

1. Take a copy of the backup file and store it in a different location. Just for safety so that if there is a trouble in modification, you still have the original backup file.

2. Now, convert the backup file (.Data) by renaming the file as .ZIP.

3. Open a new folder, Unzip the file (Right click->Extract here).

4. Remove the File attachments and Inline images folder and place it outside the new folder. Also, ensure to remove the actual backup file converted as ZIP.

5. Now, copy all the files in the New folder and add them as a Zip file(Copy all files->Right click->7 Zip->Add to New folder.zip)

6. Once the file is zipped, rename it with the original backup file name and change the file extension back to .DATA. Store this in another new folder for easy reference say Modified Backup.

7. Now try restoring the backup from the Modified folder and the restore should work fine now.

8. Login as Administrator and check your data.

9. Once it is fine, copy the Inline images and FileAttachments.zip  to the ManageEngine\Servicedesk Plus MSP folder.

10. Then, ensure to unzip the FileAttachments.zip on to the same location.

If you have any issues, kindly drop an email to sdpmsp@manageengine.com with the steps tried, screenshots of the error message and the Build number which you have issue with.

          • Related Articles

          • Restore fails due to CRC error

            When the Backup is Password protected, then during restore, the application is unable to unzip the backup file due to CRC error below, Default Backup password: SDP123! java.io.IOException: invalid CRC (MAC) for file: ...
          • Steps to take PGSQL Dump Backup and Restore

            PGSQL – DUMP – Backup Procedure : Login to the MSP application server and perform the below steps, 1. Start the application To take Postgres (Psql) Dump : 3. Open a command prompt and navigate into <ServiceDeskPlus-MSP>/pgsql/bin directory. 4.  ...
          • How do I restore the backup data?

            Step 1: To restore the backed up data,Command Prompt as an Administrator, ManageEngine\ServiceDeskPlus – MSP\bin>restoreData.bat When it is prompted, please invoke the backup (just part 1) and it will start the restore process thereby automatically ...
          • Unable to save Preventive maintenance tasks

            Issue: Unable to update just one PM task with more than 300 tasks. When tried to save the PM task, it simply throws "User does not have sufficient privilege".  Cause: By default we would have restricted for these many tasks added in PM task. We can ...
          • Move database from one machine to another

            Following is the procedure to migrate your ServiceDesk Plus – MSP database from one MSSQL to another. Step 1: Stop ManageEngine ServiceDesk Plus – MSP service. Step 2: Take a backup of the existing data and configuration under MSSQL database. From ...