Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Production to Staging and Vice Versa Expand / Collapse
Author
Message
Posted Tuesday, October 9, 2012 5:39 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, November 12, 2014 10:44 AM
Points: 2,634, Visits: 3,985
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.
Post #1370333
Posted Wednesday, October 10, 2012 11:50 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 9:43 PM
Points: 2,841, Visits: 3,986
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
Post #1371219
Posted Thursday, October 11, 2012 3:43 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, November 12, 2014 10:44 AM
Points: 2,634, Visits: 3,985
Thanks a lot Bhuvnesh.
Post #1371312
Posted Friday, October 12, 2012 3:24 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Monday, December 15, 2014 9:36 AM
Points: 652, Visits: 1,901
Make sure to remove / change email addresses etc.

It's a simple point, but could have horrible consequences if overlooked.
Post #1371970
Posted Friday, October 12, 2012 3:40 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 9:43 PM
Points: 2,841, Visits: 3,986
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
Post #1371978
Posted Friday, October 12, 2012 4:01 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Monday, December 15, 2014 9:36 AM
Points: 652, Visits: 1,901
I agree...but some things are worth mentioning explicitly.
Post #1371991
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse