Srinath, I think that as others have said before, the RC=1914 is a fairly generic SQL Backup API error. More information is required for further help. Depending on how you have structured your scripts for logging, there should be a logfile, either sqlfull.log or sqlincr.log, tdpsql.log, dsierror.log that will give more detailed information than just the RC=1914.
Failing that, try a manual log backup of the database and post the output. e.g. >From TDP directory tdpsqlc backup Pirate log To give you an idea of the kind of format of error that would be of more help, it might look something like this [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP LOG is terminating abnormally. Microsoft SQL-DMO (ODBC SQLState: 42000) (HRESULT:0x80041070) Thanks Leigh -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Gopinathan, Srinath Sent: 05 October 2006 09:46 To: ADSM-L@VM.MARIST.EDU Subject: [SPAM: 6.200] [ADSM-L] Backup Failures Hi All, I am regularly getting having this schedule failed. When I check the TSM logs, I see the following. These 4 databases fail regularly. Could anyone help out on how to troubleshoot this issue? 10/03/2006 00:08:37 ANE4993E (Session: 3071, Node: GBCWBLEIPSF3-SQL) TDP MSSQL ACO3002 Data Protection for SQL: log backup of database distribution from server GBCWBLEIPSF3 failed, rc = 1914. (SESSION: 3071) 10/03/2006 00:09:24 ANE4993E (Session: 3071, Node: GBCWBLEIPSF3-SQL) TDP MSSQL ACO3002 Data Protection for SQL: log backup of database Pirate from server GBCWBLEIPSF3 failed, rc = 1914. (SESSION: 3071) 10/03/2006 00:09:26 ANE4993E (Session: 3071, Node: GBCWBLEIPSF3-SQL) TDP MSSQL ACO3002 Data Protection for SQL: log backup of database Pirate_Audit from server GBCWBLEIPSF3 failed, rc = 1914. (SESSION: 3071) 10/03/2006 00:09:26 ANE4993E (Session: 3071, Node: GBCWBLEIPSF3-SQL) TDP MSSQL ACO3002 Data Protection for SQL: log backup of database Pirate_Audit from server GBCWBLEIPSF3 failed, rc = 1914. (SESSION: 3071) SCHEDULED_START ACTUAL_START DOMAIN_NAME SCHEDULE_NAME NODE_NAME STATUS RESULT 2006-10-03 12:00:00.000000 2006-10-03 12:01:23.000000 EXOMSSQL MSSQL_SEV3_LOG GBCWBLEIPSF3-SQL Failed 402 Thanks and Regards Srinath G This e-mail has been scanned for viruses by the Cable & Wireless e-mail security system - powered by MessageLabs. For more information on a proactive managed e-mail security service, visit http://www.cw.com/uk/emailprotection/ The information contained in this e-mail is confidential and may also be subject to legal privilege. It is intended only for the recipient(s) named above. If you are not named above as a recipient, you must not read, copy, disclose, forward or otherwise use the information contained in this email. If you have received this e-mail in error, please notify the sender (whose contact details are above) immediately by reply e-mail and delete the message and any attachments without retaining any copies.