test environment best practice

Hi, I need to set up test environments for multiple mission critical severs each running data warehouses on sql server 2008. Can anyone suggest some good practice guidelines to follow.
geoffcolesAsked:
Who is Participating?
 
geoffcolesAuthor Commented:
Thanks for this. Sorry for a delay in replying to your post. What I'm after is some guidance on best practice on setting up a test environment. I'm not sure if your response addresses that?

For example, I have a sql 2008 instance on a production server, along with some custom executable files and folders with different permission levels etc. I need to make sure that everything on the production system is mirrored in a test environment so that any new developments can be tested on the test environment reliably before being deployed to production. . I am after some best practice guidance or steps on how to set up a test environment.
0
 
geoffcolesAuthor Commented:
Thank you for pointing me to this article. This is just what I need!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.