Attaching previous database to new installation

Discussion in 'microsoft.public.sqlserver.clustering' started by iqv1, Jun 13, 2007.

  1. iqv1

    iqv1 Guest

    I have a Active/Passive cluster and have installed the SQL 2005.
    What I would like to know, before I proceed with my configurations (since it
    is my first time in a cluster environment) is whether I will need to attach
    the database (lets call it DBX) to SQL Server on both the servers seperately,
    or do i only have to attach the database DBX to SQL Server on the active
    machine.
    Like i said this is my first time so i want to be very sure before i proceed.
     
    iqv1, Jun 13, 2007
    #1
    1. Advertisements

  2. iqv1

    Linchi Shea Guest

    You don't attach the database to any node. Rather, you attach it to the SQL
    Server instance regardless which node the instance may be running at the
    time. In general, a SQL Server operation doesn't care where the SQL instance
    is running.

    Linchi
     
    Linchi Shea, Jun 14, 2007
    #2
    1. Advertisements

  3. iqv1

    iqv1 Guest

    thanks for you advice Linchi... I will try that

     
    iqv1, Jun 15, 2007
    #3
  4. Keep in mind that SQL Server will only be active on one node at a time. The
    disks will only be visible from this active node; so, that is where you must
    place the database files.

    Then, as Linchi stated, you must run the attach process through the SQL
    Server instance, just like you would on a stand-alone system.

    You connect to the SQL Server instance through the failover cluster server
    name dedicated for SQL Server, not specific node names.

    Sincerely,


    Anthony Thomas


    --

    proceed.
     
    Anthony Thomas, Jul 14, 2007
    #4
  5. iqv1

    Igor Guest

    Hello!

    I suppose that you know the answer on my question.

    The matter is that we have Active/Passive cluster and SQL Server running on
    it. I want to deploy clr procedure. I have already created dll and make
    script which creates assembly in database, but I don't know do I need to
    implement this script on both servers or I can implement it on active node
    only.
     
    Igor, Apr 21, 2009
    #5
  6. Igor,

    Since the assembly is created in the database, then you should only need to
    deploy to the SQL Server. (You can even script it out of the database and
    get a big binary string of the DLL in your script.)

    You should not need to care which cluster node it is running on.

    RLF
     
    Russell Fields, Apr 21, 2009
    #6
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.