Post reply

span sql instance across servers

  • December 4, 2012 at 6:12 pm

    #267103

    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.

  • December 5, 2012 at 12:55 am

    #1565589

    Is connections come from SqlProd1?

  • December 5, 2012 at 8:13 am

    #1565783

    Yes.

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

  • December 5, 2012 at 9:25 am

    #1565817

    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

  • December 5, 2012 at 9:33 am

    #1565823

    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?

    Thank you for your time.

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

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

  • December 5, 2012 at 11:38 am

    #1565876

    Thanks everyone.

    I was looking for something like Shared Databases but not read only.

    Now I know better.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply