TDPSQL Restore Problem
2003-10-08 23:19:13
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:kris.bock AT qr.com DOT au
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.
**********************************************************************
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- TDPSQL Restore Problem,
Bock, Kris <=
|
|
|