?
Solved

test environment best practice

Posted on 2011-02-11
4
Medium Priority
?
542 Views
Last Modified: 2012-05-11
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.
0
Comment
Question by:geoffcoles
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 

Author Comment

by:geoffcoles
ID: 34926257
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
 
LVL 8

Accepted Solution

by:
jimsweb earned 2000 total points
ID: 34927849
0
 

Author Closing Comment

by:geoffcoles
ID: 34929140
Thank you for pointing me to this article. This is just what I need!
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question