Alternative for Full Backup - Trimmed backup

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.

  1. 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.

You can contact our support at support@supportcenterplus.com for any assistance.


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

                      • 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 ...
                      • 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     ...
                      • Inputs required for analyzing Performance Issues

                        We need a couple of details to analyze Performance issue. So, please send the below details : Below mentioned details should be gathered before restarting the application. 1. Let us know whether you are taking Scheduled full backup or backup without ...
                      • Workaround to add Customized Header Image

                        This is applicable only 110XX builds (till 11021). In 11021 users are unable to change the logo of the header image due to the Issue ID - 2538. Below mentioned is the workaround to add Customized Header Image.  -> In the application path ...
                      • Backup Issue - Stream closed error

                        Backup Error - Stream closed error : I request you to follow the below steps and take a trimmed back and check the case. 1. Shut down the application. 2. Edit the backUpData.bat (present under SupportCenter\bin folder)  and tune the backUpData.bat as ...