1. Community Tip: Please Give Thanks to Those Sharing Their Knowledge.
    If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful.
  2. Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)
    Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.

How do I configure TDP for SQL with MS SQL Server cluster?

Discussion in 'Microsoft SQL Server' started by daleto, Apr 12, 2012.

  1. daleto

    daleto Active Newcomer

    Joined:
    Apr 10, 2005
    Messages:
    10
    Likes Received:
    0
    We are going to implement this setup

    [Machine A] [Machine B]
    [SQL Server A] [SQL Server B]
    [Database A] <-----> [Database A]

    The [Database A] can be active on either [SQL Server A] or [SQL Server B]
    And if it is active on one of the instances,
    for example [SQL Server A], than the other instance [SQL Server B] will have a passive database [Database A]

    The problem is that the namespace (filespace) on the TSM Server has the "instance name" as a part of the backup.
    So how do I handle this setup?

    Should I take a backup of both SQL Server instances [SQL Server A&B] ?
    Will the TDP report the none active database [Database A] as a failed backup?

    Please help me

    Regards Tomas
     
  2.  
  3. moon-buddy

    moon-buddy ADSM.ORG Moderator

    Joined:
    Aug 24, 2005
    Messages:
    6,535
    Likes Received:
    299
    Occupation:
    Electronics Engineer, Security Professional
    Location:
    Somewhere in the US
  4. Mita201

    Mita201 ADSM.ORG Senior Member

    Joined:
    Apr 20, 2006
    Messages:
    512
    Likes Received:
    12
    Occupation:
    System Engineer
    Location:
    Beograd, Serbia
    Is it a MS Cluster or SQL Log shipping?
     

Share This Page