Alternative for Full Backup - Trimmed backup
Applicable till 8.1 version (Till 8121 builds)
Nowadays the database size is huge in various users instance. It is because the indexing related files, archived files, file attachments are folder are huge in size. Due to which either our application is facing performance issues, Backup is not working or time taken to restore is huge.
To overcome this, we have a workaround. Please follow this and check whether it works. Try this in the user non-operational hours.
1. Edit the backUpData.bat (present under SupportCenter\bin folder) and add the below entries in the last line(in bold alone) and also tune the backUpData.bat as the conversation files are huge in size around 10 Gb
Refer content in Bold and make changes.
%JAVA% %JAVA_OPTS% -Xms128m -Xmx4096m -Dsdp.backup.home=%BACKUP_DIR% -Dsdp.backup.type=%1 -Dignore.folder=index,archive -Dsdp.backup.ignoretables=AaaAccSessionAudit,AaaAccHttpSession,AaaAccSessionProp,AaaAccSession,AuditRecord,OperationAuditRecord,ErrorLog,ErrorLogOwner,AuditResultProperty,AuditResourceProp,AuditOperProperty,RecentItems -cp %CLASS_PATH% com.adventnet.servicedesk.tools.SDBackUp
PS : Tune according to the server capacity (above is applicable for 8 GB RAM machine)
2. Disable the automatic backup scheduling from the user interface. Admin -> Global Settings -> Backup Scheduling -> Edit scheduling.
3. Open a command prompt and navigate into SupportCenter\bin folder and execute backUpData.bat --trimmed
For Version 11
Open a command prompt and navigate into SupportCenter\bin folder and execute backUpData.bat --trimmed
For Version 14:
Open a command prompt and navigate into SupportCenter\bin folder and execute trimmedBackUpData.bat
This will take backup without attachments.
PS : You can copy the inlineimages , fileAttachments, custom, index folders present under SupportCenter home folder separately from the production server to the restored server. These folders combined is equal to full back up of the database.
- Once the backup is complete, a backup file with .data extension is placed in the Backup folder under the Supportcenter Plus\trimmed backup directory. You can use it for further usage.
Some users may get Stream Closed Error at the final stage (post taking the backup), we can ignore the message.
In case you still find any errors, please send the SDPbackup.log file present under SupportCenter\bin folder and also the error thrown in the command prompt.
PS : In case , we ask this trimmed backup for our analysis , just send the final trimmedback up taken.
PS : In case , we ask this trimmed backup for our analysis , just send the final trimmedback up taken.
If you are using SQL database, just take the .bak file (SQL Backup) and restore it in a test SQL environment.
You can also use our inbuilt - Backup scheduling feature.
Goto Admin -> Backup scheduling and disable File Attachments and save the configuration only with Database. Wait for the backup to get completed.
(This method dont need shut down of the application)
Dont uninstall the existing installation till all your expected goal is completed.
=======
Attached are the sample files, you can replace this files under SupportCenter\bin folder and continue to take the backup file.
In case of Linux environment - use the .sh file.
in case of windows environment - rename the txt file as bat file (batch file) and then use it.
New to ADSelfService Plus?
Related Articles
Transaction log full
Logs: Depends On Me: com.adventnet.persistence.DataAccessException: [TierComponent] The transaction log for database 'supportcenter' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases ...Steps for Performance Tuning
Supportcenter Plus performance can be improved by tuning the JAVA performance as said below : For version 8: 1. Shut down the application. 2. Navigate into \SupportCenter\server\default\conf 3. Edit the file -> wrapper.conf with administrator ...Java and PGSQL Tuning for better performance of the application
This article is common for ServiceDesk Plus MSP and Supportcenter Plus applications. Application performance is based on multiple factors. To gain better performance, we need to tune JAVA / PGSQL. For ticket inflow high environment and more users ...How to take a backup in SDP-MSP
Note: In 10.6 when running a backup using backdata.bat/backdata.sh the backup file will be in .ezip format. Backup with .ezip format can be restored to the same database platform only. For example a backup with .ezip when taken from postgres DB ...Scheduled Backup Failure
Sometimes the scheduled backup fails due to the below error in the logs, Error Message org.postgresql.util.PSQLException: An I/O error occured while sending to the backend. at ...