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 |
|
uofmoo
Starting Member
6 Posts |
 Posted - 2007-06-12 : 11:52:59
|
| Good morning,I am a DBA and my boss recently recommended that we change our QA environment so that we don't have any databases on it unless they are actively being tested. This would be to save hardware costs.The only issue I can think of at this point is that promotion to our QA environment would take up to 2 hours for some of our larger databases if we have to restore production databases to qa for every QA run.Is this a good idea? How do you run your QA (full or partial copy of prod)? Any input appreciated.Thank you. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-06-12 : 12:09:47
|
| Depends on your process.If your qa is scheduled in advance then it's not a problem - the schedule will include setting up the environment and it's possibley better to build that from scratch.If you have little things you want to get through quickly then it's a problem - but then if you leave the databases (and other things there) you don't know what you are testing against as it will be affected by previous tests.Note you will have to update your QA backup after every release for the model you are moving to.Disk space is cheap though - usually cheaper than the manpower costs in trying to reduce it.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2007-06-12 : 13:21:50
|
quote:
Originally posted by uofmoo
Good morning,I am a DBA and my boss recently recommended that we change our QA environment so that we don't have any databases on it unless they are actively being tested.
What is this guy? A manager at Burger King?Brett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam |
|
|
|
uofmoo
Starting Member
6 Posts |
Posted - 2007-06-12 : 14:41:34
|
| thanks! |
|
|
|
|
|
|
QA Environment?