Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
CanadaDBA
583 Posts |
 Posted - 2005-11-17 : 09:22:38
|
| Environment: Win2k3, SQL2k SP3What is the best practice to be assure that from software point of view, my Test server is identical to Production? I want to focus on SQL Server and Windows settings. Is there a checklist?Canada DBA |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2005-11-17 : 11:17:48
|
| Use "Ghost" or equivalent to clone the Prod machine, and script (under vss control) the diffences to be applied....ie name, ip, domain, etc....would be on my "postit". |
 |
|
|
CanadaDBA
583 Posts |
Posted - 2005-11-17 : 19:30:38
|
  Andrew, I am not sure I could get much from your post. You mean use a third party utility to create exact production on my Test server? What is the vss? And how to find the differences? And at last what or where is your "postit"?  quote:
Originally posted by AndrewMurphy
Use "Ghost" or equivalent to clone the Prod machine, and script (under vss control) the diffences to be applied....ie name, ip, domain, etc....would be on my "postit".
Canada DBA |
|
|
|
CanadaDBA
583 Posts |
Posted - 2005-11-17 : 19:32:46
|
| Someone suggested me to compare the results of sp_configure from the two servers. Is it that so easy?Canada DBA |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2005-11-18 : 05:46:40
|
| "Ghost"ing a machine creates a clone of a pc/server. The software to do it may be called "Ghost"...and yes i would suspect it's a 3rd party s/w.VSS...Visual Source Safe...place to store important objects so that you can see their change history + differences....usually put all our VB + SQL code there, to allow multiple devs work on different versions of the same code. VIP s/w for any coding team!! Other non M$ varieties exist.My postit...differences between the 2 servers should be small enough to fit on one!!!sp_configure...not aware of that facility. may only look at the SQL configuration...what about o/s differences? |
|
|
|
|
|
|
|
|
Identical Test and Production