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 |
|
scazikiss
Starting Member
12 Posts |
 Posted - 2013-04-11 : 10:20:20
|
| hello, we have 2 databases independents. my question is : is that better for creating 2 databases in the same instance or 2 databases in 2 instances...? what are the advantages and disadvantages..? thanks for your help. regard.regard |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2013-04-12 : 07:37:47
|
| Two instances means increased management overhead , potential extra licensing costs, slower rebuild . If you have Instance specific configurations you need to make - then two instances may be suitable. Are these for Production or Dev?Jack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
scazikiss
Starting Member
12 Posts |
Posted - 2013-04-12 : 08:30:59
|
| there are for production.and theses databases will be mirroring. i think that is better for 2 instances separately for security and maintenance. but for memory , 2 instances that means more memory.. is that truth..? regard.regard |
|
|
|
|
|
|
creation of 1 instance or 2 instances