TDP SQL backup is getting failed with Error code 402

[tmlsuresh]

Hi All,

I have a TDP SQL backup in a Cluster environment. The nodes in cluster are

1. SPT-DB-PRD01 and 2. SPT-DB-PRD02.

My problem is TDP SQL backup is failing in PRD01 and when the resources fail over to PRD02, backup is getting succesfull.

ERROR message in SQLSCHED.log is as follows

ACO5422E Received the following from the MS SQL server:
12/04/2012 19:01:28 An exception occurred while executing a Transact-SQL statement or batch.
12/04/2012 19:01:28 Cannot open backup device 'TDPSQL-00001720-0000'. Operating system error 0x80070002(The system cannot find the file specified.).

12/04/2012 19:01:28 BACKUP DATABASE is terminating abnormally.

12/04/2012 19:01:28 Changed database context to 'master'. (HRESULT:0x80131501)

Please help....

 

[domino]

http://adsm.org/forum/showthread.php?16949-Failed-TDP-Automated-Backup-ver-5-5-clustered

http://www-01.ibm.com/support/docview.wss?uid=swg21446091

 

[tmlsuresh]

Could you please elaborate on this issue...

Thanks

 

[moon-buddy]

Could you please elaborate on this issue...

Thanks

The links pointed out by Domino are self explantory. The first link, I mentioned on the post that accounts that control the SQL environment should have the proper rights.

The second link details what the setup should look like.