ADSM-L

Re: [SPAM: 6.200] [ADSM-L] Backup Failures

2006-10-05 06:16:18
Subject: Re: [SPAM: 6.200] [ADSM-L] Backup Failures
From: Leigh Reed <L.Reed AT MDX.AC DOT UK>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 5 Oct 2006 10:43:29 +0100
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.

<Prev in Thread] Current Thread [Next in Thread>
  • Re: [SPAM: 6.200] [ADSM-L] Backup Failures, Leigh Reed <=