link to the need to setup a development and test environment

Is there any link out there on the need to setup an environment ? I know its
needed, just looking to find some official link
Also how do you sync up production databases to these environments ? Do you
do it daily ? backup and restore ?
You do not need to restore the database daily or too often. It depends on
how updated data the developers require. Be careful if you have done schema
changes to the development database and you restore a new copy.
Use the backups that you do on the production environment. That will help
you to test your backup and recovery strategy.
Ben Nevarez, MCDBA, OCP
"Hassan" <hassan@.hotmail.com> wrote in message
news:e7L7BAi%23FHA.504@.TK2MSFTNGP09.phx.gbl...
> Is there any link out there on the need to setup an environment ? I know
> its needed, just looking to find some official link
> Also how do you sync up production databases to these environments ? Do
> you do it daily ? backup and restore ?
>
sql