Use the following steps to create a subclient for dump backups:
-
From the CommCell Browser, navigate to Client Computers | <Client> | File System iDataAgent.
-
Right-click the <BackupSet>, point to All Tasks, and then click New Subclient.
-
In the Subclient Name box, type the subclient name.
-
Click the Storage Device tab.
-
In the Storage Policy box, select the storage policy.
-
Click the Pre/Post Process tab.
-
Click Browse to locate the dump directory path and add the script for dump backup.
The script should contain the dbunload command. Use the dbunload utility to obtain the SQL dump of the database, which can be used to rebuild the database. The dbunload command should include the output dump directory as a pre-scan process.
-
Click the Content tab.
-
Click Add Paths.
-
Add the path for the reload SQL file and dump data directory to the sub-client content and click OK.
-
Click OK to create a subclient for dump backup. Perform the backups of this subclient at periodic intervals.
The dump backup script for UNIX and Windows based file systems will be as follows:
dbunload -c "Connect-String" -r <dump-file-name> <directory-to-dump-data>
where
-r : Name of the generated reload ISQL command file (default "reload.sql")
Example (UNIX)
dbunload -y -c "eng=demo11;dbn=mydb;uid=dba;pwd=sql;LINKS=ALL" -r /temp/myDBReload.sql /temp/dataDump
Example (Windows)
dbunload -y -c "eng=demo11;dbn=mydb;uid=dba;pwd=sql;LINKS=ALL" -r d:\myDBReload.sql D:\dataDump