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:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Gopinathan, Srinath
Sent: 05 October 2006 09:46
To: ADSM-L AT VM.MARIST DOT 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.
|