Sona,
I'm not sure exactly what problem you are having now but are you
following the steps in the "Using Tivoli Data Protection for Microsoft SQL
Servers" redbook. There is a specific step you need to go through when
restoring the mast db using the Rebuildm.exe utility. The steps are in
section 7.1 of the redbook. Sorry if you are already following those steps
but the few times that I have done this I followed the steps in the manual
and everything came back without issue.
Kyle Payne
[EMAIL PROTECTED]
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
Sona Sood
Sent: Thursday, January 23, 2003 6:52 PM
To: [EMAIL PROTECTED]
Subject: trying to restore SQL master DB
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.
####################################################################
