SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 creation of 1 instance or 2 instances
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

scazikiss
Starting Member

USA
12 Posts

Posted - 04/11/2013 :  10:20:20  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

United Kingdom
2008 Posts

Posted - 04/12/2013 :  07:37:47  Show Profile  Visit jackv's Homepage  Reply with Quote
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
Go to Top of Page

scazikiss
Starting Member

USA
12 Posts

Posted - 04/12/2013 :  08:30:59  Show Profile  Reply with Quote

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
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000