Post reply

1 SQL Server 100 satellite databases

  • December 16, 2009 at 2:41 am

    #136006

    HI

    I have a SQL Server which is used by 100 remote SQL Express installs, these are based all around the UK, if I need to administer these databases (ie compare data from the outlet (remote db) to the head office db) I need to connect via logmein and then run a query on the remote db or browse the data there and at head office.

    The DB's communicate using SQL Broker, is there a better way of administering these db's - can I add linked servers using the external IP and port of the remote db? I can telnet to and from each db?

    Any ideas, greatly appreciated.

    Thanks

    Craig

  • December 16, 2009 at 2:56 am

    #1092879

    Why not use Central Management Servers with the SQL 2008 Management Studio and look into using Policy Based Management.

    Facts are stubborn things, but statistics are more pliable - Mark Twain
    Carolyn
    SQLServerSpecialists[/url]

  • December 16, 2009 at 2:59 am

    #1092881

    I'm currently using SQL Server 2005 and SQL Server Express 2005, is there anything available for this version?

    I'm not sure they'd go for a SQL upgrade at the moment.

    Thanks

    --Edit, or can I use SQL Server 2008 management console to manage the other versions of SQL and remote sites? Thats would be great....

  • January 11, 2010 at 4:24 am

    #1101697

    Sorry for the delayed response, you can use SQL 2008 central management server to manage SQL 2005 servers.

    Facts are stubborn things, but statistics are more pliable - Mark Twain
    Carolyn
    SQLServerSpecialists[/url]

  • January 12, 2010 at 3:52 pm

    #1102809

    Server Objects -> Linked Servers. A query would look something like this.

    SELECT *

    FROM [My Linked Instance01].[Mydatabase].[dbo].[customer]

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

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