SQL Restore Fails
2003-09-25 14:19:44
I am attempting to restore a 90 gig SQL database to a test server ( not the
original location).
The Restore will start and I will have disk activity but then it will stop and
generate a TCPIP connection failure,
09/25/2003 11:30:03 Request : RESTORE
09/25/2003 11:30:03 Database Input List : -
09/25/2003 11:30:03 Object Input List : -
09/25/2003 11:30:03 Group Input List : -
09/25/2003 11:30:03 File Input List : -
09/25/2003 11:30:03 Log or Set Input List : -
09/25/2003 11:30:03 Into Input List : -
09/25/2003 11:30:03 Undo File : -
09/25/2003 11:30:03 Relocate Input List : -
09/25/2003 11:30:03 To Input List : -
09/25/2003 11:30:03 Include Inactive Files? : Yes
09/25/2003 11:30:03 Number of Buffers : 3
09/25/2003 11:30:03 Buffer Size : 1024
09/25/2003 11:30:03 Number of SQL Buffers : 0
09/25/2003 11:30:03 SQL Buffer Size : 1024
09/25/2003 11:30:03 Number of Stripes specified : 1
09/25/2003 11:30:03 Wait for Tape Mounts? : Yes
09/25/2003 11:30:03 DateTime : -
09/25/2003 11:30:03 MarkName : -
09/25/2003 11:30:03 After : -
09/25/2003 11:30:03 Recovery : Yes
09/25/2003 11:30:03 Replace : Yes
09/25/2003 11:30:03 Restricted User Only? : Yes
09/25/2003 11:30:03 Partial? : -
09/25/2003 11:30:03 TSM Options File : C:\Program
Files\Tivoli\TSM\TDPSql\dsm.opt
09/25/2003 11:30:03 TSM Nodename Override : -
09/25/2003 11:30:03 Fromsqlserver : HQSAPPRO
09/25/2003 11:30:03 Sqlserver : MACSAPTST
09/25/2003 11:30:03
09/25/2003 12:46:22 ACO5436E A failure occurred on stripe number (0), rc = 418
09/25/2003 12:46:22 ANS1017E (RC-50) Session rejected: TCP/IP connection
failure
09/25/2003 12:46:23 Restore of PRO failed.
09/25/2003 12:46:23 ANS1017E (RC-50) Session rejected: TCP/IP connection
failure
09/25/2003 12:46:23 Total database backups inspected: 1
09/25/2003 12:46:23 Total database backups requested for restore: 1
09/25/2003 12:46:23 Total database backups restored: 0
09/25/2003 12:46:23 Total database skipped: 0
09/25/2003 12:46:23 Throughput rate: 0.67 Kb/Sec
09/25/2003 12:46:23 Total bytes transferred: 3,145,728
09/25/2003 12:46:23 Elapsed processing time: 4,580.04
Secs
09/25/2003 12:46:23 ACO0151E Errors occurred while processing the request.
Does anyone have any ideas , what is causing this? I am using the latest SQLTDP
5.1.5.15, I have upgraded the B/A client to the latest 5.2 version, hope this
is not causing the problem.
I have increased the TSM server's commtimeout to 1800 ( 30 minutes) and it does
not change a thing.
Thanks for your help
John Stephens
www.Storserver.com
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- SQL Restore Fails,
John Stephens <=
|
|
|