Re: Multiple databases

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 10/26/04 

Date: Tue, 26 Oct 2004 18:31:10 +0200

I prefer multiple databases unless I have a reason to go multiple instances. 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"sql" <sql@discussions.microsoft.com> wrote in message 
news:78A84D8C-C8DD-4AC1-BDEA-A54332CDB8D1@microsoft.com...
> Which is better..
>
> Multiple databases on a single instance of SQL
> OR
> Multiple instances of Sql server,  for multiple databases?

Relevant Pages

  • Re: what about: instances of sql
    ... multiple databases. ... SQL Server Enterprise Edition on Win 2K Advanced Server or Win 2K3 Enterprise ... As far as the licensing goes, if you are licensing your SQL Server under the ... processor mode but hosting multiple databases will server you better. ...
    (microsoft.public.sqlserver.server)
  • Re: Instances of SQL Server 2000?
    ... have multiple databases ... For multiple instances, yes. ... Depending on the edition of SQL Server, the licensing model you're using, ... You really should verify licensing compliance with a local ...
    (microsoft.public.sqlserver.server)
  • Re: T-SQL
    ... multiple databases on the same instance of SQL Server. ... Some data of the report is confidential data. ... I am given all necessary usernames and passwords. ...
    (comp.databases.ms-sqlserver)
  • Instances of SQL Server 2000?
    ... Our application requires multiple instances of SQL Server 2000 in order to have multiple databases, which the app clients use. ...
    (microsoft.public.sqlserver.server)
  • Re: Multiple databases
    ... Multiple instances consumes much, much more resources. ... multi-instance SQL Servers except for dev and test environments. ... Looking for a SQL Server replication book? ... > Multiple instances of Sql server, for multiple databases? ...
    (microsoft.public.sqlserver.server)