Master SQL Server Database restore - Veritas Net Backup

This is a discussion on Master SQL Server Database restore - Veritas Net Backup ; 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 ! ...

+ Reply to Thread
Results 1 to 2 of 2

Thread: Master SQL Server Database restore

  1. Master SQL Server Database restore

    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




  2. Re: Master SQL Server Database restore


    Hugo, did you get a response on this? We are having the same errors, working
    w/support and not getting anywhere.
    Thanks! Tania

    "Hugo" wrote:
    >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
    >
    >
    >



+ Reply to Thread