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 <[EMAIL PROTECTED]> | 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
