ADSM-L

trying to restore SQL master DB

2003-01-23 19:52:23
Subject: trying to restore SQL master DB
From: Sona Sood <SSood AT BSAL.COM DOT AU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 24 Jan 2003 11:21:42 +1030
Hi,
 
We are running TSM 5.1.0 on Win 2000. I am doing testing at the DR site
and am having some trouble. I was able to restore the TSM DB OK. Then I
started restoring the SQL master DB using TDP SQL (v.2.2). I stopped
SQL, restarted it in single user mode and then restored from TDP SQL.
Tivoli asks for tape , mounts the tape, tries to read from tape then SQL
comes up with error message and SQL stops itself, Tivoli breaks
connection and restore fails. Here is the SQL log. There are no error
messages in Tivoli logs. Does anyone have any suggestions? Any help will
be appreciated.
 
Thanks
regards,
Sona 
 
SQL Error Log:
 
2003-01-23 16:33:22.53 server    Copyright (C) 1988-2000 Microsoft
Corporation.
2003-01-23 16:33:22.54 server    All rights reserved.
2003-01-23 16:33:22.54 server    Server Process ID is 1360.
2003-01-23 16:33:22.56 server    Logging SQL Server messages in file
'g:\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
2003-01-23 16:33:22.57 server    SQL Server is starting at priority
class 'normal'(4 CPUs detected).
2003-01-23 16:33:22.90 server    SQL Server configured for thread mode
processing.
2003-01-23 16:33:22.92 server    Using dynamic lock allocation. [2500]
Lock Blocks, [5000] Lock Owner Blocks.
2003-01-23 16:33:22.95 server    Attempting to initialize Distributed
Transaction Coordinator.
2003-01-23 16:33:24.10 spid3     Warning ******************
2003-01-23 16:33:24.12 spid3     SQL Server started in single user mode.
Updates allowed to system catalogs.
2003-01-23 16:33:24.12 spid3     Starting up database 'master'.
2003-01-23 16:33:24.18 spid3     0 transactions rolled back in database
'master' (1).
2003-01-23 16:33:24.18 spid3     Recovery is checkpointing database
'master' (1)
2003-01-23 16:33:24.25 spid3     Server name is 'xxxxxxx'.
2003-01-23 16:33:24.25 server    Using 'SSNETLIB.DLL' version '8.0.534'.
2003-01-23 16:33:24.25 spid5     Starting up database 'model'.
2003-01-23 16:33:24.26 spid7     Starting up database 'msdb'.
2003-01-23 16:33:24.26 spid8     Starting up database 'pubs'.
2003-01-23 16:33:24.28 spid9     Starting up database 'Northwind'.
2003-01-23 16:33:24.32 spid5     Clearing tempdb database.
2003-01-23 16:33:24.35 server    SQL server listening on xx.x.x.x: xxxx.
2003-01-23 16:33:24.35 server    SQL server listening on xxx.x.x.x:
xxxx.
2003-01-23 16:33:24.46 server    SQL server listening on TCP, Shared
Memory, Named Pipes.
2003-01-23 16:33:24.46 server    SQL Server is ready for client
connections
2003-01-23 16:33:24.90 spid5     Starting up database 'tempdb'.
2003-01-23 16:33:24.95 spid3     Recovery complete.
2003-01-23 16:33:24.95 spid3     SQL global counter collection task is
created.
2003-01-23 16:34:26.48 spid51    Using 'xpstar.dll' version
'2000.80.534' to execute extended stored procedure 'xp_servicecontrol'.
2003-01-23 16:39:08.42 spid51    Unnamed tape (Family ID: 0x10371d6a,
sequence 1) mounted on tape drive 'TDPSQL-00000B14-0000'.
2003-01-23 16:39:08.62 spid51    Error: 9001, Severity: 21, State: 1.
2003-01-23 16:39:08.64 spid51    Error: 3151, Severity: 21, State: 0.
 
 
 

####################################################################

This e-mail is confidential and is intended solely for the use of the
individual or entity to whom it is addressed. If you are not an
intended recipient then you have received this e-mail in error and
any use, dissemination, forwarding, printing or copying is strictly
prohibited. You should contact the sender by return then delete all
the material from your system.

####################################################################

<Prev in Thread] Current Thread [Next in Thread>