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

[daleto]

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

 

[moon-buddy]

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

Go through these pages:

http://publib.boulder.ibm.com/tividd/td/DPSQLN/SH26-4111-01/en_US/HTML/ab5m1m13.htm

 

[Mita201]

Is it a MS Cluster or SQL Log shipping?