Results 1 to 3 of 3
  1. #1
    Newcomer
    Join Date
    Apr 2005
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

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

    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. #2
    Moderator moon-buddy's Avatar
    Join Date
    Aug 2005
    Location
    Somewhere in the US
    Posts
    5,909
    Thanks
    4
    Thanked 231 Times in 226 Posts

    Default

    Simple answer - you need to setup a clustered server environment for the SQL database.

    Go through these pages:

    http://publib.boulder.ibm.com/tividd...L/ab5m1m13.htm
    Ed

  3. #3
    Senior Member
    Join Date
    Apr 2006
    Location
    Beograd, Serbia
    Posts
    491
    Thanks
    3
    Thanked 3 Times in 3 Posts

    Default

    Is it a MS Cluster or SQL Log shipping?

Similar Threads

  1. Configure SQL schedule backups on windows cluster
    By adsm04 in forum Microsoft SQL Server
    Replies: 5
    Last Post: 03-29-2009, 06:38 AM
  2. TDP SQL on cluster unable to backup SQL Database
    By sailesh in forum Backup / Archive Discussion
    Replies: 8
    Last Post: 07-12-2007, 05:43 AM
  3. TDP for SQL with a Veritas Cluster
    By lorenzo.franklin in forum TDP/Application Layer Backup
    Replies: 0
    Last Post: 02-17-2006, 04:57 PM
  4. Replies: 1
    Last Post: 12-16-2005, 05:58 AM
  5. Restoring a SQL database with TSM SQL server TDP v5.1.5.0
    By gavinring in forum TDP/Application Layer Backup
    Replies: 1
    Last Post: 07-15-2004, 04:36 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •