Hi !

Netbackup 5.1 MP5 on Windows 2003, MS-SQL 2000 on Windows 2003.

Can someone explain me how to restore Master Database....

I already know that I must start SQL Server with -m parameter.... but it
still not working !

Here is my log file :
================================================== ================
OPERATION RESTORE
OBJECTTYPE DATABASE
DATABASE "master"
NBIMAGE "ma9.MSSQL7.MA9.db.master.~.7.001of001.200701300402 08..C"
SQLHOST "MA9"
NBSERVER "SC9"
BROWSECLIENT "bma9"
MAXTRANSFERSIZE 0
BLOCKSIZE 7
RESTOREOPTION REPLACE
RECOVEREDSTATE RECOVERED
ENDOPER TRUE

INF - LOAD STARTED USING
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
Batch = C:\Program
Files\VERITAS\NetBackup\dbext\mssql\temp\__11_36_0 1_125_00.bch, Op# = 1.
INF - Using backup image
'ma9.MSSQL7.MA9.db.master.~.7.001of001.20070130040 208..C'.
INF - restore database "master" from VIRTUAL_DEVICE='VNBU0-2528-2572' with
blocksize = 65536, maxtransfersize = 65536, buffercount = 1, replace ,
recovery
INF - #Stripes: 1, #Bufs per stripe 1, From: NetBackup on SC9
INF - Created VDI object for SQL Server instance <*DEFAULT*>. Connection
timeout is <300> seconds.
Restore started Wed Jan 31 11:36:06 2007


11:36:09 (43427.001) Restoring from image created 01/30/07 04:02:13
11:36:10 (43427.001) INF - Data socket = sc9.1030
11:36:10 (43427.001) INF - Name socket = sc9.1627
11:36:11 (43427.001) INF - Job id = 43427
11:36:11 (43427.001) INF - Backup id = bma9_1170147733
11:36:11 (43427.001) INF - Backup time = 1170147733
11:36:11 (43427.001) INF - Policy name = SQLFull1
11:36:12 (43427.001) INF - Snapshot = 0
11:36:12 (43427.001) INF - Frozen image = 0
11:36:12 (43427.001) INF - Backup copy = 0
11:36:12 (43427.001) INF - Master server = sc9
11:36:13 (43427.001) INF - Use shared memory = 0
11:36:13 (43427.001) INF - Restore id = 43427.001
11:36:13 (43427.001) INF - Encrypt = 0
11:36:13 (43427.001) INF - Client read timeout = 300
11:36:13 (43427.001) INF - Media mount timeout = 0
11:36:14 (43427.001) INF - client = bma9
11:36:14 (43427.001) INF - requesting_client = bma9
11:36:14 (43427.001) INF - browse_client = bma9
11:36:17 (43427.001) INF - Beginning restore from server sc9 to client bma9,
file L:\sc9-dsk-l\bma9_1170147733_C1_F1.
11:36:21 /ma9.MSSQL7.MA9.db.master.~.7.001of001.200701300402 08..C
11:36:27 (43427.001) Status of restore from image created 01/30/07 04:02:13
= the requested operation was successfully completed

11:36:29 INF - Server status = 0
11:36:30 (43427.xxx) INF - Status = the requested operation was successfully
completed.

INF - DBClient has been closed for stripe #0
CONTINUATION: - Component not found in the registry
ERR - Error 1 has been returned from QuerySQLServerInfo
INF - OPERATION #1 of batch C:\Program
Files\VERITAS\NetBackup\dbext\mssql\temp\__11_36_0 1_125_00.bch FAILED with
status 1. Elapsed time = 71(71) seconds.
INF - Results of executing Files\VERITAS\NetBackup\dbext\mssql\temp\__11_36_0 1_125_00.bch>:
<0> operations succeeded. <1> operations failed.
================================================== ================

Any idea ?


Hugo