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.
New to ADSelfService Plus?
Related Articles
How do I restore the backup data?
NOTE: For builds > 10.6 While migrating to different database you can use backupdataold.bat / backupdataold.sh. Here backup will be in .data format and this can be restored in across DB platform. While restoring .data file we have to use below ...Unable to restore
1.CRC (9412-9423): Download 7zip and extract the contents. The corrupted files will be listed during extracting (but those files will be extracted in the specified location). Replace those files again in the backup using 7zip (Drag those ...How to change the database from MySQL/PostgreSQL to MSSQL
The steps mentioned below are applicable only if you migrate the DB from PgSQL to MSSQL. This means that the application server is going to remain the same. The data alone is going to be transferred to MSSQL DB from the existing PgSQL DB. For ...How do I convert the database from PGSQL to MSSQL?
1. Stop ManageEngine ServiceDeskPlus – MSP service. 2. Take a backup of the existing data and configuration under PGSQL database by following the below steps. Open CMD as an administrator and execute command to start the data backup. ...How to restore the database of supportcenter plus in a new instance? (Applicable from 11.0 version)
1. Find out the build number of the live server. You can know it from About Product (inside ? icon)in the top right of the user interface. 2. Download the same version from the below link * http://archives.manageengine.com/support-center/ ...