Steps to Restore Production DB to Test Environment?

[Former Member]

Hi All,

I encountered a difficulty on restoring a production DB to a test environment on BPC (Microsoft) and would like to seek everyone assistance on how to do it,

so far the steps that I did,

1. Installed fresh BPC APP and DB with different set of hostname than prod.

2. verify the fresh installation BPC APP and DB is working

3. restore the AppServer DB from production to newly created BPC DB

4. update record in AppServer in BPC DB to point into this hostname, since restoration of the AppServer DB will point to the production hostname

5. restore our BPC Database e.g. BPC from production to newly created BPC DB.

until this step then I hit issue that BPC DB can't be updated, it able to load the template but the unable to update the record.

any pointer on how to fix this error?

Thank you,

Regards,

Ura

[former_member186498]

Hi Ura,

first of all I see you have a lot of opened questions. Please remember that is your duty to close the discussion when solved showing the "corrrect answer" this will help in future other users with same issue, see please How to close a discussion and why

Regard to the question you should give more informations about your systems and bpc version installed on these, in the meanwhile you can look at these linkw about backup to verify if they give you a hint.

How to automate backups on BPC for Microsoft and

Best Practices for Backup on BPC for Microsoft

Regards

     Roberto