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 |
|
vdavid70
Yak Posting Veteran
67 Posts |
 Posted - 2005-12-22 : 07:56:18
|
| Hi,I have got two databases within the same sql instance. One is a life database and the other a test. Now my question is if i make any changes in the test environment is there any chance of this change affecting the life environment. If it does will it be advisable to create another instance on the same server and create the test database in this second instance. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2005-12-22 : 08:33:02
|
quote:
if i make any changes in the test environment is there any chance of this change affecting the live environment.
Should be No. I use the word 'should' as I do not know what the Application does and is there any jobs setup that transfer / linked between your life and test DB. Actually it will be even better if your test database is house in another server. So you will not accidentally mess up your live DB when you forgot to change DB or running the wrong script on the wrong DB.Something like "Oops. I ran that on my live DB."delete myveryimportanttable ortruncate table myliveanddeathtable And the live DB performance will not be affected by any untuned queries in test db.-----------------[KH]Learn something new everyday |
 |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2005-12-22 : 09:17:42
|
| If the two databases are running on the same physical box then any changes to dev could affect live, either in performance, disk space, or "other". This is fairly true regardless of whether or not they live in seperate instances. You should have a seperate physical box for the dev environment.-------Moo. :) |
|
|
|
|
|
|
SQL Instances