What's the proper way of setting up staging?

kulmam92kulmam92 Posts: 12
edited December 5, 2011 10:18AM in SQL Compare Previous Versions
I watched the "SQL Server Central Webinar Series #11: A Sandbox Development Process – Using SQL Source Control and SQL Virtual Restore" and red-gate product seems like really good tool.
In that webinar the following environments are mentioned. I have some question about setting up each environment

1. sendbox
virtual restore looks like really promising but how does it work when I update big amount of data or add column with default value to the big table? Will the duration be the same as normal database?
2. shared server
3. QA
4. staging
what's do proper way of setting up staging?
It looks like it should be a exact same copy of production but does this mean that it should have same data as production? If so, how can I set up that environment? Should I restore a backup of production every night?
5. production

Comments

Sign In or Register to comment.