Linked server setup on SQL Cluster

  • I am new to clustering.

    Do we need to create linked server on both the nodes ? and how about the jobs?

  • Before you do anything - read up on the subject first, as it is quite a big one.

    Start here:

    http://www.sql-server-performance.com/2002/clustering-intro/

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • muthyala_51 (6/29/2012)


    I am new to clustering.

    Do we need to create linked server on both the nodes ? and how about the jobs?

    No, they are created at the instance level, when an instance fails over all of this is available on the partner node

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

    "Ya can't make an omelette without breaking just a few eggs" 😉

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

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