Solved

test environment best practice

Posted on 2011-02-11
4
531 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
  • 2
  • 2
4 Comments
 
LVL 8

Expert Comment

by:jimsweb
ID: 34869052
0
 

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 500 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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

726 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