Komrades,
I am attempting a TDPSQL restore for a customer and running into
problems. TDPSQL Ver 5.1.5/TSM Server 5.2.1.1. We run full backups on the weekend
and diffs during the week. Unfortunately, the customers ran a MSSQL full backup (not
using TDP) in between the TDP full and diffs. As Murphy would have it, they have now
broken the DB and require a restore. When restoring, the full restore completes but
the TDP fails on the diff. I know little about MSSQL, but enough to suspect that the
MSSQL full backup is causing the grief. Is this correct and, if so, can anything be
done?
10/09/2003 12:01:51
=========================================================================
10/09/2003 12:01:51 Request : RESTORE
10/09/2003 12:01:51 Database Input List : -
10/09/2003 12:01:51 Object Input List : -
10/09/2003 12:01:51 Group Input List : -
10/09/2003 12:01:51 File Input List : -
10/09/2003 12:01:51 Log or Set Input List : -
10/09/2003 12:01:51 Into Input List : -
10/09/2003 12:01:51 Undo File : -
10/09/2003 12:01:51 Relocate Input List : -
10/09/2003 12:01:51 To Input List : -
10/09/2003 12:01:51 Include Inactive Files? : No
10/09/2003 12:01:51 Number of Buffers : 3
10/09/2003 12:01:51 Buffer Size : 1024
10/09/2003 12:01:51 Number of SQL Buffers : 0
10/09/2003 12:01:51 SQL Buffer Size : 1024
10/09/2003 12:01:51 Number of Stripes specified : 1
10/09/2003 12:01:51 Wait for Tape Mounts? : Yes
10/09/2003 12:01:51 DateTime : -
10/09/2003 12:01:51 MarkName : -
10/09/2003 12:01:51 After : -
10/09/2003 12:01:51 Recovery : Yes
10/09/2003 12:01:51 Replace : Yes
10/09/2003 12:01:51 Restricted User Only? : No
10/09/2003 12:01:51 Partial? : -
10/09/2003 12:01:51 TSM Options File : C:\Program
Files\Tivoli\TSM\TDPSql\dsm.opt
10/09/2003 12:01:51 TSM Nodename Override : -
10/09/2003 12:01:51 Fromsqlserver : BNEDEVSQL22
10/09/2003 12:01:51 Sqlserver : BNEDEVSQL22
10/09/2003 12:01:51
10/09/2003 12:35:51 Restore of NRSOnline failed.
10/09/2003 12:35:51 [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot apply the
backup on device 'TDPSQL-00000770-0000' to database 'NRSOnline'.
10/09/2003 12:35:51 [Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE DATABASE is
terminating abnormally.
10/09/2003 12:35:51 Total database backups inspected: 2
10/09/2003 12:35:51 Total database backups requested for restore: 2
10/09/2003 12:35:51 Total database backups restored: 1
10/09/2003 12:35:51 Total database skipped: 0
10/09/2003 12:35:51 Throughput rate: 6,554.05 Kb/Sec
10/09/2003 12:35:51 Total bytes transferred: 13,686,684,672
10/09/2003 12:35:51 Elapsed processing time: 2,039.33 Secs
10/09/2003 12:35:51 ACO0151E Errors occurred while processing the request.
10/09/2003 12:36:25
=========================================================================
Cheers,
K.B.
Kris Bock
Storage Consultant
Information Services Division
QR
mailto:[EMAIL PROTECTED]
Phone: 07 3235-3610
Fax: 07 3235-3620
**********************************************************************
This email and any files transmitted with it are confidential and intended solely for
the use of the individual or entity to whom they are addressed. If you have received
this email in error please notify the system manager of QR.
This message has been scanned for the presence of computer viruses. No warranty is
given that this message upon its receipt is
virus free and no liability is accepted by the sender in this respect.
This email is a message only; does not constitute advice and should not be relied upon
as such.
**********************************************************************
