Home Knowledge Articles Series 7 How To Backup And Restore Upfront Data Store
Follow us on Twitter


Countries

50.1%United States United States
7.6%India India
7%United Kingdom United Kingdom
5.1%Australia Australia
4.8%Canada Canada

Visitors

Today: 30
Yesterday: 111
Last Week: 3353
This Month: 9182
Last Month: 16191
Total: 382835


How To Backup And Restore Upfront Data Store PDF Print E-mail
(0 votes, average 0 out of 5)
Written by Martijn Christenhusz   
Wednesday, 20 May 2009 19:55

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

Comments

Please login to post comments or replies.
Last Updated on Thursday, 28 January 2010 18:39
 
 

Login

For more content en features!



CogKnowHow Newsletter

Season's Greetings


Receive HTML?

Polls

How many users are working on your Cognos environment?