Database and Repository Backup

Siegmar,


as far as I understand it you need to do a backup related to the DB. with Derby I found this http://www.ibm.com/developerworks/data/library/techarticle/dm-0502thalamati/index.html. I hope this gives you the options for backing up and restoring the Derby DB.

I am not sure Derby supports online backup withiut shutting down the server. Other DB's such as DB2 support that.

Please note that the Jazz Team Server stores an Index for the work items typically in the workitemindex directory by default in the server directory (configured in the teamserver.properties). I think this should be backed up too. I am not sure how to recreate the index in case it is lost I think it is repotools -reindex. After restoring a DB without having backed workitemindex up you would have to run that.

As a quick solution you can also stop the server and compress the Derby Database typically named repositoryDB in the server directory. I zip repositoryDB and workitemindex in one zip for demo purposes.

You could also use repotools but I don't think this is the suggested way to do it it is rather for migrating.
* use repotools -export to export your whole DB
* repotools -import can recreate everything

Hope this helps,

Ralph

Hi,

I am using RTC Express-C under Windows and would like to know how can I make a BACKUP of the Database (Derby) and the Repository?
How do I RESTORE this BACKUP, after a new RTC installation?

Thanks

How can we take the project area backup on RTC..?.

Can we backup a project area of one RTC server and restore it on another RTC server..?. :?:

On 24-Nov-09 10:53 AM, muralindia wrote:

How can we take the project area backup on RTC..?.

Can we backup a project area of one RTC server and restore it on
another RTC server..?. :?:

No. It has been commented several times in this new newsgroup. That
feature is under discussion for 3.0

Regards,

Chemi.