Re: Share Database with 2 SQL Servers.

#1

No. Each SQL Server\instance has exclusive control over its databases.

--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com

I support the Professional Association for SQL Server
www.sqlpass.org

"Jack Victor" <Nomail (AT) JustPostReply (DOT) tv> wrote

Quote:

Hi,

Is it possible to have 2 sql servers inserting into the same database. In
my specific case, the servers would be inserting to different tables and
there would be no overlap. I don't want to split the database because
reporting would be based on data from the whole database. I guess this is
kind of likc load balancing.

Thanks!
Jack

#2

Why would you need more than 900 bytes in an index key? Anything that large
really needs to go to full-text search instead.

--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com

I support the Professional Association for SQL Server
www.sqlpass.org

"Jack Victor" <Nomail (AT) JustPostReply (DOT) tv> wrote

Quote:

Damn! At least I know this ahead of time. Our db has almost no indexes
(just the primary keys really) and because of the 900 byte index limit I
can't create indexes on the fields that we would be frequently searching
on. But at least since have have few indexes and rows don't go through
multiple table joins, we should have high insert rates.

I didn't know about sqlpass.org. Thanks for the tip!

On Fri, 21 May 2004 10:21:47
-0400, Geoff N. Hiten wrote:

No. Each SQL Server\instance has exclusive control over its databases.

#3

True, but there are some serious performance and design consequences with
linked servers. Also, if one server goes down, the whole system is offline
so you are lowering your overall availability rather than raising it.

--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com

I support the Professional Association for SQL Server
www.sqlpass.org

"Cathy Soloway" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:

While each instance manages it's own databases, you can link databases so
that you can manipulate the data from multiple databases as one big instance

if you need to by quantifying your SQL with

Quote:

instancename.databasename.owner.table.field

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Share Database with 2 SQL Servers.

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering

Re: Share Database with 2 SQL Servers. - 05-21-2004 , 09:21 AM

Re: Share Database with 2 SQL Servers. - 05-21-2004 , 11:48 AM

Re: Share Database with 2 SQL Servers. - 05-26-2004 , 02:03 PM