It's all about the answers!

Ask a question

Database and Repository Backup


Siegmar Gieseler (621) | asked Nov 21 '09, 1:58 p.m.
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

3 answers



permanent link
Ralph Schoon (63.1k33646) | answered Nov 24 '09, 3:38 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
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

permanent link
Murali Dhandapani (11698) | answered Nov 24 '09, 4:39 a.m.
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..?. :?:

permanent link
Jose Miguel Ordax Cassa (2.4k4126100) | answered Nov 24 '09, 6:08 a.m.
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.

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.