Post reply

Production to Staging and Vice Versa

  • October 9, 2012 at 5:39 am

    #282974

    Hi Experts,

    Please let me know what all need to check before and after restoring a database from production to stage and vice versa.

    Thanks in Advance.

  • October 10, 2012 at 11:50 pm

    #1547889

    there will be few checks before staging build

    1. sufficient space on log and data drives plus tempdb drives too

    2. from where to keep backup files and all backup are available or not

    3. what would be downtime and impact of staging server.

    4. no application or user should be connected during this

    but yes after data refresh there are couple of things

    1. all required databases got restored ot not ?

    2. job

    3. login fix

    4. implementation of DR if required.

    5. application mapping

    6. web servers and other servers configuration setting

    7. sometimes data masking is also required to avoid security breach

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • October 11, 2012 at 3:43 am

    #1547967

    Thanks a lot Bhuvnesh.

  • October 12, 2012 at 3:24 am

    #1548512

    Make sure to remove / change email addresses etc.

    It's a simple point, but could have horrible consequences if overlooked.

  • October 12, 2012 at 3:40 am

    #1548518

    David McKinney (10/12/2012)

    Make sure to remove / change email addresses etc.

    It's a simple point, but could have horrible consequences if overlooked.

    that is part of data masking

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • October 12, 2012 at 4:01 am

    #1548529

    I agree...but some things are worth mentioning explicitly.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply