Help needed to restore AW DB and HDS DB

[Renni John]

Hi Team,

please let me know the steps to restore backup of AW DB and HDS DB from side A ( Admin workstation ) to side B (Admin workstation ) .

Regards

Renni John

[Sivanesan Rathinam · Accepted solution]

For AWDB you can Initialize Local DB from Side B AWDB which will pull all Real Time info from Logger DB 

For HDS you need to take SQL BKP from Side A HDS and restore the same in Side B SQL, Post which check the Recovery Key from Logger to HDS and Table Count of TCD and other tables  which should be same on both Sides.

[Renni John]

Hi Sivanesan

I have restored HDS -B database from HDS -A database back up and when I started distributer service AW DB synched as well  .

But when I compared  space and usage summary via icmdba tool ,TCD & RCD row count are not matching with HDS _A . Some rows are missing in HDS B database .

Could you please guide me how to fix this .

Regards

Renni john