cancel
Showing results for 
Search instead for 
Did you mean: 

sql2000 restore is not initiating

Zahid_Haseeb
Moderator
Moderator
Partner    VIP    Accredited

Environment

Netbackup server = 7.01

netbackup client = 7.0

MS Sql Server version = 2000

 

My sql restore is not initiating in the activity monitor. i am doing alternative restore.

i have attached the bpcd logs of netbackup server for reference:

1 ACCEPTED SOLUTION

Accepted Solutions

Marianne
Level 6
Partner    VIP    Accredited Certified

I found status 37 in bprd log:

17:28:12.178 [2064.6092] <2> bpcd_remote_write: from client tpsbkp.tpsonline.com: DestHost:TPSBKP ReqUser:root RemotePath:(37)logs/mssql_backup_failures/122410.rpt OpenMode:a Data:(1)

See TN: http://www.symantec.com/docs/TECH137534

Also status 12:
17:28:12.288 [2064.6092] <2> bpcd_remote_write: couldn't open remote file /C/Program Files/Veritas/NetBackup/logs/mssql_backup_failures/122410.rpt on client TPSBKP, error = 2
17:28:12.288 [2064.6092] <2> bpcd_remote_write: INF - bpcd_remote_write status = 12
17:28:12.288 [2064.6092] <2> process_request: bpcd_remote_write failed - status = file open failed (12)

 

Does the user starting the restore on client TPSBKP have write access to log directories in C:\Program Files\Veritas\NetBackup\logs?
 

Please also share more info about your environment:

Master server name
Source client
Destination client

 

It is unclear which client you actually want to restore. You seem to be looking for SQL type backups for all of the following:

17:10:53.281 [4932.4996] <2> fileslist:    client = tpsbdc
17:11:17.593 [5600.236] <2> fileslist:    client = 192.168.22.40
17:11:18.093 [4296.1356] <2> fileslist:    client = 192.168.22.40
17:11:20.546 [5084.772] <2> fileslist:    client = 192.168.22.40
17:11:20.780 [4360.4684] <2> fileslist:    client = 192.168.22.40
17:11:30.671 [1284.6132] <2> fileslist:    client = tpsbdc
17:11:30.999 [364.6128] <2> fileslist:    client = tpsbdc
17:18:04.947 [4312.728] <2> fileslist:    client = TPSBDC
17:18:05.291 [5328.4388] <2> fileslist:    client = TPSBDC
17:18:28.103 [1988.1812] <2> fileslist:    client = backup
17:18:28.619 [3040.5940] <2> fileslist:    client = backup
17:18:29.087 [6040.5196] <2> fileslist:    client = BACKUP
17:18:29.587 [4088.4400] <2> fileslist:    client = BACKUP
17:18:52.743 [980.1788] <2> fileslist:    client = tpsbdc
17:18:53.072 [4732.5180] <2> fileslist:    client = tpsbdc
17:19:41.008 [4712.4560] <2> fileslist:    client = tpsbdc
17:19:41.337 [4200.6000] <2> fileslist:    client = tpsbdc
17:26:31.554 [5212.4868] <2> fileslist:    client = tpsbdc
17:26:31.882 [1632.4396] <2> fileslist:    client = tpsbdc
18:25:02.279 [4140.4144] <2> fileslist:    client = backup
18:25:02.811 [1360.4160] <2> fileslist:    client = backup
18:25:03.404 [4120.4192] <2> fileslist:    client = BACKUP
18:25:03.904 [2544.4496] <2> fileslist:    client = BACKUP
18:25:08.389 [3768.2960] <2> fileslist:    client = backup
18:25:08.889 [4868.4804] <2> fileslist:    client = backup
18:25:09.357 [4812.4688] <2> fileslist:    client = BACKUP
18:25:09.842 [1532.1536] <2> fileslist:    client = BACKUP
18:25:42.935 [2000.4580] <2> fileslist:    client = tpsbdc
18:25:45.654 [4492.2276] <2> fileslist:    client = tpsbdc
18:28:51.603 [4596.4456] <2> fileslist:    client = fileserver
18:28:52.791 [4932.5092] <2> fileslist:    client = fileserver
18:28:53.275 [840.168] <2> fileslist:    client = FILESERVER
18:28:53.775 [4656.5332] <2> fileslist:    client = FILESERVER
18:29:02.790 [5324.5340] <2> fileslist:    client = fileserver
18:29:03.290 [5476.5500] <2> fileslist:    client = fileserver
18:29:03.790 [5612.5560] <2> fileslist:    client = FILESERVER
18:29:04.290 [5636.5600] <2> fileslist:    client = FILESERVER
18:29:25.055 [5784.5896] <2> fileslist:    client = fileserver
18:29:25.555 [5980.5984] <2> fileslist:    client = fileserver
18:29:26.039 [6056.6140] <2> fileslist:    client = FILESERVER
18:29:26.539 [6088.304] <2> fileslist:    client = FILESERVER
18:29:31.320 [3956.6128] <2> fileslist:    client = fileserver
18:29:31.836 [3852.1744] <2> fileslist:    client = fileserver
18:29:32.336 [1768.5996] <2> fileslist:    client = FILESERVER
18:29:32.836 [1336.6108] <2> fileslist:    client = FILESERVER
18:29:38.351 [1196.2248] <2> fileslist:    client = tpsbdc
18:29:38.679 [900.4128] <2> fileslist:    client = tpsbdc
18:50:46.836 [5332.5700] <2> fileslist:    client = tpsbdc
18:50:47.164 [5444.5436] <2> fileslist:    client = tpsbdc

All of the above were recorded in bprd log as diffrent SQL backup list attempts.

 

According to this section you are trying to restore to master server, right?
MASTERSERVER TPSBKP
CLIENT tpsbkp
 

You need to start the restore from the destination client. Please post dbclient log on the destination client and also the restore script that was created after browsing for backups.

View solution in original post

4 REPLIES 4

Zahid_Haseeb
Moderator
Moderator
Partner    VIP    Accredited

i faced the below error on status view

 

 

# This batch file was created for an operation on host TPSBDC using
# the SQL Server instance <default>.
# Move this file to the Veritas\NetBackup\dbext\MSSQL\ directory
# on host <TPSBDC>. Execute it there using the NetBackup
# Database Extension GUI or the NetBackup Scheduler.
#  
#  This is a template for the database MOVE command.
#  
OPERATION RESTORE
OBJECTTYPE DATABASE
RESTORETYPE MOVE
#  
#  Replace the database name in the following line with the name of the database that you
#  want to move to. Also remove the hash mark <#> which precedes the keyword <DATABASE>.
#  
DATABASE "trkmaster"
#  Replace the file path <E:\Live DataBases\trkmaster.mdf>
#  with a new file path. Also remove the hash mark <#> which precedes the keyword <TO>.
#  The target of the MOVE keyword must be "trkmaster_dat". 
MOVE  "trkmaster_dat"
TO  "d:\SQL\trkmaster\trkmaster.mdf"
#  Replace the file path <E:\Live DataBases\trkmaster_log.ldf>
#  with a new file path. Also remove the hash mark <#> which precedes the keyword <TO>.
#  The target of the MOVE keyword must be "trkmaster_log". 
MOVE  "trkmaster_log"
TO  "d:\SQL\trkmaster\trkmaster_log.ldf"
# The following image is type: Full
NBIMAGE "tpsbdc.MSSQL7.TPSBDC.db.trkmaster.~.7.001of001.20101202171455..C"
SQLHOST "BACKUP"
NBSERVER "TPSBKP"
BROWSECLIENT "tpsbdc"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
RESTOREOPTION REPLACE
RECOVEREDSTATE RECOVERED
NUMBUFS 2
ENDOPER TRUE
 
INF - RESTORE STARTED USING
Microsoft SQL Server  2000 - 8.00.194 (Intel X86) 
Aug  6 2000 00:57:48 
Copyright (c) 1988-2000 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2) 
Batch = C:\Documents and Settings\Rep-Tps\Desktop\trkmaster2-12-2010.bch, Op# = 1.
INF - Using backup image tpsbdc.MSSQL7.TPSBDC.db.trkmaster.~.7.001of001.20101202171455..C
INF - restore database "trkmaster" from VIRTUAL_DEVICE='VNBU0-6048-6028-1293198780' with blocksize = 65536, maxtransfersize = 4194304, buffercount = 2, replace , norecovery, move 'trkmaster_dat' to 'd:\SQL\trkmaster\trkmaster.mdf', move 'trkmaster_log' to 'd:\SQL\trkmaster\trkmaster_log.ldf', replace
INF - Number of stripes: 1, Number of buffers per stripe 2.
ERR - Error in CoCreateInstance: 0x80040154.
    CONTINUATION: - The requested lookup key was not found in any active activation context.
INF - OPERATION #1 of batch C:\Documents and Settings\Rep-Tps\Desktop\trkmaster2-12-2010.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 3(0) seconds.
INF - Results of executing <C:\Documents and Settings\Rep-Tps\Desktop\trkmaster2-12-2010.bch>: 
<0> operations succeeded. <1> operations failed.
 
 
 
 
I found the TN but after following the below TN i am still facing the same error
 

Marianne
Level 6
Partner    VIP    Accredited Certified

You need to check bprd log on master server as starting point.

Unless the master server is used as client, I have never found any use for bpcd on a master server.

Also ensure you have dbclient log on destination client.

Zahid_Haseeb
Moderator
Moderator
Partner    VIP    Accredited

bprd logs

Marianne
Level 6
Partner    VIP    Accredited Certified

I found status 37 in bprd log:

17:28:12.178 [2064.6092] <2> bpcd_remote_write: from client tpsbkp.tpsonline.com: DestHost:TPSBKP ReqUser:root RemotePath:(37)logs/mssql_backup_failures/122410.rpt OpenMode:a Data:(1)

See TN: http://www.symantec.com/docs/TECH137534

Also status 12:
17:28:12.288 [2064.6092] <2> bpcd_remote_write: couldn't open remote file /C/Program Files/Veritas/NetBackup/logs/mssql_backup_failures/122410.rpt on client TPSBKP, error = 2
17:28:12.288 [2064.6092] <2> bpcd_remote_write: INF - bpcd_remote_write status = 12
17:28:12.288 [2064.6092] <2> process_request: bpcd_remote_write failed - status = file open failed (12)

 

Does the user starting the restore on client TPSBKP have write access to log directories in C:\Program Files\Veritas\NetBackup\logs?
 

Please also share more info about your environment:

Master server name
Source client
Destination client

 

It is unclear which client you actually want to restore. You seem to be looking for SQL type backups for all of the following:

17:10:53.281 [4932.4996] <2> fileslist:    client = tpsbdc
17:11:17.593 [5600.236] <2> fileslist:    client = 192.168.22.40
17:11:18.093 [4296.1356] <2> fileslist:    client = 192.168.22.40
17:11:20.546 [5084.772] <2> fileslist:    client = 192.168.22.40
17:11:20.780 [4360.4684] <2> fileslist:    client = 192.168.22.40
17:11:30.671 [1284.6132] <2> fileslist:    client = tpsbdc
17:11:30.999 [364.6128] <2> fileslist:    client = tpsbdc
17:18:04.947 [4312.728] <2> fileslist:    client = TPSBDC
17:18:05.291 [5328.4388] <2> fileslist:    client = TPSBDC
17:18:28.103 [1988.1812] <2> fileslist:    client = backup
17:18:28.619 [3040.5940] <2> fileslist:    client = backup
17:18:29.087 [6040.5196] <2> fileslist:    client = BACKUP
17:18:29.587 [4088.4400] <2> fileslist:    client = BACKUP
17:18:52.743 [980.1788] <2> fileslist:    client = tpsbdc
17:18:53.072 [4732.5180] <2> fileslist:    client = tpsbdc
17:19:41.008 [4712.4560] <2> fileslist:    client = tpsbdc
17:19:41.337 [4200.6000] <2> fileslist:    client = tpsbdc
17:26:31.554 [5212.4868] <2> fileslist:    client = tpsbdc
17:26:31.882 [1632.4396] <2> fileslist:    client = tpsbdc
18:25:02.279 [4140.4144] <2> fileslist:    client = backup
18:25:02.811 [1360.4160] <2> fileslist:    client = backup
18:25:03.404 [4120.4192] <2> fileslist:    client = BACKUP
18:25:03.904 [2544.4496] <2> fileslist:    client = BACKUP
18:25:08.389 [3768.2960] <2> fileslist:    client = backup
18:25:08.889 [4868.4804] <2> fileslist:    client = backup
18:25:09.357 [4812.4688] <2> fileslist:    client = BACKUP
18:25:09.842 [1532.1536] <2> fileslist:    client = BACKUP
18:25:42.935 [2000.4580] <2> fileslist:    client = tpsbdc
18:25:45.654 [4492.2276] <2> fileslist:    client = tpsbdc
18:28:51.603 [4596.4456] <2> fileslist:    client = fileserver
18:28:52.791 [4932.5092] <2> fileslist:    client = fileserver
18:28:53.275 [840.168] <2> fileslist:    client = FILESERVER
18:28:53.775 [4656.5332] <2> fileslist:    client = FILESERVER
18:29:02.790 [5324.5340] <2> fileslist:    client = fileserver
18:29:03.290 [5476.5500] <2> fileslist:    client = fileserver
18:29:03.790 [5612.5560] <2> fileslist:    client = FILESERVER
18:29:04.290 [5636.5600] <2> fileslist:    client = FILESERVER
18:29:25.055 [5784.5896] <2> fileslist:    client = fileserver
18:29:25.555 [5980.5984] <2> fileslist:    client = fileserver
18:29:26.039 [6056.6140] <2> fileslist:    client = FILESERVER
18:29:26.539 [6088.304] <2> fileslist:    client = FILESERVER
18:29:31.320 [3956.6128] <2> fileslist:    client = fileserver
18:29:31.836 [3852.1744] <2> fileslist:    client = fileserver
18:29:32.336 [1768.5996] <2> fileslist:    client = FILESERVER
18:29:32.836 [1336.6108] <2> fileslist:    client = FILESERVER
18:29:38.351 [1196.2248] <2> fileslist:    client = tpsbdc
18:29:38.679 [900.4128] <2> fileslist:    client = tpsbdc
18:50:46.836 [5332.5700] <2> fileslist:    client = tpsbdc
18:50:47.164 [5444.5436] <2> fileslist:    client = tpsbdc

All of the above were recorded in bprd log as diffrent SQL backup list attempts.

 

According to this section you are trying to restore to master server, right?
MASTERSERVER TPSBKP
CLIENT tpsbkp
 

You need to start the restore from the destination client. Please post dbclient log on the destination client and also the restore script that was created after browsing for backups.