Copy Repository From DB

[imran_khatyan]

Can I Copy a repository database from SQL Server and use it as a Seperate Repository identical data to original?

[Sashidhar · Accepted solution]

yes , you can do it. 
if you want to create a repository under same system db , then you need to change repository name , its hexidb (you can give random), its transaction location  in DB . and you need to restore using name you choose as repository name .

[RGenin]

Thanks for the answer ! Just to confirm :

So all you need is to open the targed DB, and change DBNAME,DBIDABS and REFERENCEFILE in table A_DBINFOS ?

We had asked our DBAs to clone a Repository to another name, but upon restoration (without changing the afore mentioned table) we have this issue :

Thanks again !

[jcamara · Accepted solution]

Hello RGenin,

We have all the information related to duplicating an environment or a repository of an existing environment in our V2R1 online documentation here:

https://doc.mega.com/hopex-v2r1-en/#page/SUP%2FRDBMS_Environment_Duplication_-_1_-_SQL_Server.Backup...

The section you would want to focus on now is this one:

I hope that helps

Regards,

JCAMARA

[RGenin]

Thank you for the swift response. ...excactly what I needed and in front on my eyes...

[jcamara]

You are very welcome and glad I could help. To be fair, it was buried a bit in the online documentation