I am a SQL-Head (as Mark so elegantly put it), and one with more experience
than most. The fact that the DBAs can do a backup from SQL Enterprise Manager
(or whatever) does *not* prove that this is not a SQL Server error. It may,
sadly, give substantial evidence that they are stubborn or relatively
inexperienced DBAs if that's how they diagnose things.
I have seen this error pop up in different circumstances, and I urge you to
try the workaround that Del mentions below (which is the same as the one from
the MS KB article). If this works, then it *is* most definitely a Microsoft
problem that can be resolved either by a Hotfix or by using the tcp:servername
syntax when registering or connecting to a SQL Server.
The first time I saw this error, my intuition told me it was "probably not a
SQL thing," but note the word "probably." When I took the time to replicate
the connectivity environment of the client (which your SQL-Heads appear not to
have done), I saw the error, which led me to the KB.
We don't use SQL failover clusters at my current job (and I've only used
mostly DTC-bound clusters at other jobs) ... yet ... and this is the first job
I've had where we've used TDP for SQL Server. Since we are likely to start
using failover clusters for SQL Server in the fairly near future, I'd really
appreciate it if you could post the resolution of this problem to the list.
Thanks,
Chris
_________________________________
Chris Leonard
MCSE, MCDBA, OCP, CIW
_________________________________
The Database Guy
http://www.databaseguy.com
Brainbench MVP for Oracle Admin
http://www.brainbench.com
_________________________________
| Date: Fri, 30 Jul 2004 16:45:03 -0400
| From: Del Hoobler <hoobler AT US.IBM DOT COM>
| Subject: Re: TDP SQL errors backing up SQLSERVER Cluster on
| Windows2003
|
| Bill,
|
| Did you try this?
|
| tdpsqlc backup dbname full /sqlserver=tcp:server-name.abc.com
|
| for example:
|
| tdpsqlc backup master full /sqlserver=tcp:couples.endicott.ibm.com
|
| What happens?
|
| If you can't get it working, please ask that the PMR be
| forwarded to IBM Level 2 support. Level 2 can gather traces
| and work with Microsoft support to identify the problem.
|
| Thanks,
|
| Del
|
smime.p7s
Description: S/MIME cryptographic signature
|
