Post reply

Difference between Linked Server & CMS

  • September 16, 2011 at 4:28 am

    #247863

    Hi,

    I am planning to automate different servers. I m confused between Linked Server & CMS. Please guide..

    Sagar Sonawane
    ** Every DBA has his day!!:cool:

  • September 16, 2011 at 7:12 pm

    #1382851

    What are you planning to automate ?

    Thank You,

    Best Regards,

    SQLBuddy

  • September 16, 2011 at 9:54 pm

    #1382859

    Linked Servers are not typically used for management and automation type tasks like CMS (Central Management Server).

    CMS provides a "central" repository/group of servers to which you can administer/manage.

    A linked server is just that - a link between one server to another so that the first server has access to data in the second server.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 3 posts - 1 through 2 (of 2 total)

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