Production to Staging and Vice Versa

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Production to Staging and Vice Versa

Production to Staging and Vice Versa

Rate Topic

Display Mode

Topic Options

Author

Message

Ratheesh.K.Nair

Posted Tuesday, October 09, 2012 5:39 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 6:42 AM
Points: 2,415, Visits: 3,379

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

Bhuvnesh

Posted Wednesday, October 10, 2012 11:50 PM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 8:41 AM
Points: 2,562, Visits: 3,451

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----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post

Post #1371219

Ratheesh.K.Nair

Posted Thursday, October 11, 2012 3:43 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 6:42 AM
Points: 2,415, Visits: 3,379

Thanks a lot Bhuvnesh.

Post #1371312

David McKinney

Posted Friday, October 12, 2012 3:24 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 7:52 AM
Points: 582, Visits: 1,603

Make sure to remove / change email addresses etc.

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

Post #1371970

Bhuvnesh

Posted Friday, October 12, 2012 3:40 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 8:41 AM
Points: 2,562, Visits: 3,451

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----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post

Post #1371978

David McKinney

Posted Friday, October 12, 2012 4:01 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 7:52 AM
Points: 582, Visits: 1,603

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

Post #1371991

« Prev Topic | Next Topic »

Permissions