span sql instance across servers

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » span sql instance across servers

span sql instance across servers

Rate Topic

Display Mode

Topic Options

Author

Message

talinkio

Posted Tuesday, December 04, 2012 6:12 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, February 20, 2013 3:32 PM
Points: 5, Visits: 63

Is it possible to have a SQL Server instance, say SQLProd01, span multiple windows servers? Let's go with 3 servers each having 2 DBs but all linking back to that one named instance of SQLProd01?

Thank you for your time.

Post #1392758

ESAT ERKEC

Posted Wednesday, December 05, 2012 12:55 AM

SSC Veteran

Group: General Forum Members
Last Login: Today @ 2:19 AM
Points: 217, Visits: 697

Is connections come from SqlProd1?

Post #1392817

talinkio

Posted Wednesday, December 05, 2012 8:13 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, February 20, 2013 3:32 PM
Points: 5, Visits: 63

Yes.
I would imagine a sort of controller that would accept the connections and point them to the correct server on the back end.

Post #1393038

Chris Harshman

Posted Wednesday, December 05, 2012 9:25 AM

SSCommitted

Group: General Forum Members
Last Login: Yesterday @ 7:19 AM
Points: 1,562, Visits: 1,716

talinkio (12/4/2012)

Is it possible to have a SQL Server instance, say SQLProd01, span multiple windows servers? Let's go with 3 servers each having 2 DBs but all linking back to that one named instance of SQLProd01?

I'm not quite sure what you're saying, there's a couple of ways this question could be interpreted. in SQL Server terminology, an instance is a collection of databases all existing on the same server. You can setup something called Linked Servers which would allow queries from one instance to reference tables and views and such in another instance.

If you're asking about each server having a copy of the databases on SQLProd01 and keeping them synchronized, then this sounds like you are trying to scale out. Here's an overview article about different techniques:
http://msdn.microsoft.com/en-us/library/aa479364.aspx

Post #1393077

george sibbald

Posted Wednesday, December 05, 2012 9:33 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 3:23 PM
Points: 5,264, Visits: 11,191

talinkio (12/4/2012)

As you describe it, no. An instance is specific to a server, all databases have to be on the same server.

---------------------------------------------------------------------

Post #1393084

talinkio

Posted Wednesday, December 05, 2012 11:38 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, February 20, 2013 3:32 PM
Points: 5, Visits: 63

Thanks everyone.
I was looking for something like Shared Databases but not read only.
Now I know better.

Post #1393150

« Prev Topic | Next Topic »

Permissions