InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 09:47:48 GMT20http://www.sqlservercentral.com/Forums/Topic1370333-146-1.aspxI agree...but some things are worth mentioning explicitly.Fri, 12 Oct 2012 04:01:08 GMTDavid McKinneyhttp://www.sqlservercentral.com/Forums/Topic1370333-146-1.aspx[quote][b]David McKinney (10/12/2012)[/b][hr]Make sure to remove / change email addresses etc. It's a simple point, but could have horrible consequences if overlooked.[/quote] that is part of data maskingFri, 12 Oct 2012 03:40:56 GMTBhuvneshhttp://www.sqlservercentral.com/Forums/Topic1370333-146-1.aspxMake sure to remove / change email addresses etc. It's a simple point, but could have horrible consequences if overlooked.Fri, 12 Oct 2012 03:24:30 GMTDavid McKinneyhttp://www.sqlservercentral.com/Forums/Topic1370333-146-1.aspxThanks a lot Bhuvnesh.Thu, 11 Oct 2012 03:43:41 GMTRatheesh.K.Nairhttp://www.sqlservercentral.com/Forums/Topic1370333-146-1.aspxthere 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 thisbut yes after data refresh there are couple of things 1. all required databases got restored ot not ?2. job 3. login fix4. 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 breachWed, 10 Oct 2012 23:50:20 GMTBhuvneshhttp://www.sqlservercentral.com/Forums/Topic1370333-146-1.aspxHi 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.Tue, 09 Oct 2012 05:39:19 GMTRatheesh.K.Nair