How To Backup And Restore Upfront Data Store

-- BackUp --

1. From the command line, run the command upfpack.exe
usage: upfdbadm [-q] [[-b | -r <file>] | [-p <oldpassword> <newpassword>]]
-q : quiet mode
-b : backup data store
-r : restore data store
<file> : name of backup file
-p : change data store password
<oldpassword> : previous data store password
<newpassword> : new data store password

2. Run the command upfdbadm.exe with the parameter -b
upfdbadm.exe -b C:\BackUp\UpFrontStore.Bak

-- Restore --

1. Run the command upfdbadm.exe with the parameter -r
upfdbadm.exe -r C:\BackUp\UpFrontStore.Bak
2. Run the command upfunpack.exe with the follow parameters to delete old namespace references in the Upfront Data Store.
-ns <NameSpace> -del

You can also create a batch file for this

** Backup.bat **
D:
CD\Progra~1\Cognos\cerx\bin\
Upfpack.exe -un Admin -pw admin1234 -d D:\Backup
upfdbadm.exe -b D:\Backup\UpFrontStore.Bak

** Restore.bat **
D:
CD\Progra~1\Cognos\cerx\bin\
Upfunpack.exe -un admin -pw admin1234 -p D:\Backup\Upfpackage.pkg -ns default -del
upfdbadm.exe -r D:\Backup\UpFrontStore.Bak