TABLE OF CONTENTS
This article gives an overview of the process of backing up the database from a production server and restoring it on a staging server.
Steps to create Production DB Restoration on Stage
Below are the steps to follow during Creating the Production DB Restoration on Stage.
Step 1: Log in to SQL Database Server with your credentials.
Step 2: Execute the below-stored procedure
@Databasename: Database Name
@BackupPath: Backup Path where the database backup is stored.
@recipientList: Email to whom the server should send an alert on completion of the backup.
Step 3: After executing the query. The backup will be successfully created.Step 4: Transfer the file to the Stage database server using network path access and restore the database in the SQL server.
Step 4: Partner can restore the backup on their environment.
Step 5: If the Customer/Partner wants to restore the backup on the Amla environment, they must raise a ticket, Znode Support team will take care of the ticket.
Below are the guidelines that need to be followed before using the stage server database which is a copy of the production server database.
The below data needs to be cleaned/deleted
- Google Analytics data
- SMTP server-related data
- User’s information like email address & password
Above mentioned cleanup script will be executed only by the Launch Database Team. This is a mandatory step because the end user can get an unnecessary email once any trigger happens.
All the steps can be automated using SQL server jobs.