Message Boards

how to restore production database to test environment?

Rudrappa Devarashetty, modified 2 Years ago.

how to restore production database to test environment?

New Member Post: 1 Join Date: 5/17/21 Recent Posts

I'm creating one test environment and i'm completely installing new setup (web server ,liferay application server and Database server) and i would like to copy the production data to test environment can any one please help me with the steps how to do this 

thumbnail
Olaf Kock, modified 2 Years ago.

RE: how to restore production database to test environment?

Liferay Legend Posts: 6403 Join Date: 9/23/08 Recent Posts

You'll do that just as if you'd restore your production environment after a failure. I hope you've tested that procedure.

I have the habit or allowing people to call something a backup only if they have recently demonstrated that they can use that collection of data to restore a fully functioning system.

And that restore typically is done to a completely new system that includes everything from load balancer to persistence (e.g. database, document storage, search index).

That being said, backup instructions are here. For restoring on a test system: Make sure to anonymize the data and configure your test system in a way that it doesn't send email (or other) notifications to a legitimate production system user.

Sweeny Michel, modified 2 Years ago.

RE: how to restore production database to test environment?

New Member Post: 1 Join Date: 6/12/21 Recent Posts

Assuming that the different environments are on different SQL Servers (or at least on different Instances), then would recommend that you keep the database names on all environments exactly the same. Use permissions (e.g. Integrated security) to ensure that only the correct environment systems and users access the appropriate environment databases.

Cota Gabriela, modified 2 Years ago.

RE: how to restore production database to test environment?

New Member Post: 1 Join Date: 10/16/20 Recent Posts
  1. Create a copy-only backup of an operational database suitable for use by: 
  2. Install this backup on a different SQL Server as a discardable clone.