ADSM-L

TDPSQL Restore Problem

2003-10-08 23:19:13
Subject: TDPSQL Restore Problem
From: "Bock, Kris" <Kris.Bock AT QR.COM DOT AU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 9 Oct 2003 13:17:16 +1000
        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>