Re: Multiple databases
From: Derrick Leggett (derrickleggett_at_yahoo.com)
Date: 10/27/04
- Next message: David Gugick: "Re: Is it possible to logon to SQL Server as a different Windows user?"
- Previous message: Jonas Larsen: "Re: Ever increasing transaction log size"
- In reply to: Mark Allison: "Re: Multiple databases"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 26 Oct 2004 23:00:35 -0500
Instances provide better isolation from a security and environment
perspective. I've isolated the HR and accounting environments to their own
instances for this reason. We also have third party on a different instance
from standard production. Othe than that, the mainline production
(in-house) systems are all on one production instance.
"Mark Allison" <marka@no.tinned.meat.mvps.org> wrote in message
news:u2VtYs3uEHA.1616@TK2MSFTNGP10.phx.gbl...
> sql,
>
> Multiple instances consumes much, much more resources. I rarely use
> multi-instance SQL Servers except for dev and test environments.
> Definitely go for multi-database.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
>
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
>
> sql wrote:
> > Which is better..
> >
> > Multiple databases on a single instance of SQL
> > OR
> > Multiple instances of Sql server, for multiple databases?
- Next message: David Gugick: "Re: Is it possible to logon to SQL Server as a different Windows user?"
- Previous message: Jonas Larsen: "Re: Ever increasing transaction log size"
- In reply to: Mark Allison: "Re: Multiple databases"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
