sql2000 restore is not initiating

Question

Environment
Netbackup server = 7.01
netbackup client = 7.0
MS Sql Server version = 2000
&nbsp;
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:

marianne · Accepted Answer

I found status 37 in bprd log:
17:28:12.178 [2064.6092] &lt;2&gt; 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] &lt;2&gt; 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] &lt;2&gt; bpcd_remote_write: INF - bpcd_remote_write status = 12
	17:28:12.288 [2064.6092] &lt;2&gt; process_request: bpcd_remote_write failed - status = file open failed (12)
&nbsp;
Does the user starting the restore on client TPSBKP have write access to log directories in C:\Program Files\Veritas\NetBackup\logs?
	&nbsp;
Please also share more info about your environment:
Master server name
	Source client
	Destination client
&nbsp;
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] &lt;2&gt; fileslist:&nbsp;&nbsp;&nbsp; client = tpsbdc
	17:11:17.593 [5600.236] &lt;2&gt; fileslist:&nbsp;&nbsp;&nbsp; client = 192.168.22.40
	17:11:18.093 [4296.1356] &lt;2&gt; fileslist:&nbsp;&nbsp;&nbsp; client = 192.168.22.40
	17:11:20.546 [5084.772] &lt;2&gt; fileslist:&nbsp;&nbsp;&nbsp; client = 192.168.22.40
	17:11:20.780 [4360.4684] &lt;2&gt; fileslist:&nbsp;&nbsp;&nbsp; client = 192.168.22.40
	17:11:30.671 [1284.6132] &lt;2&gt; fileslist:&nbsp;&nbsp;&nbsp; client = tpsbdc
	17:11:30.999 [364.6128] &lt;2&gt; fileslist:&nbsp;&nbsp;&nbsp; client = tpsbdc
	17:18:04.947 [4312.728] &lt;2&gt; fileslist:&nbsp;&nbsp;&nbsp; client = TPSBDC
	17:18:05.291 [5328.4388] &lt;2&gt; fileslist:&nbsp;&nbsp;&nbsp; client = TPSBDC
	17:18:28.103 [1988.1812] &lt;2&gt; fileslist:&nbsp;&nbsp;&nbsp; client = backup
	17:18:28.619 [3040.5940] &lt;2&gt; fileslist:&nbsp;&nbsp;&nbsp; client = backup
	17:18:29.087 [6040.5196] &lt;2&gt; fileslist:&nbsp;&nbsp;&nbsp; client = BACKUP
	17:18:29.587 [4088.4400] &lt;2&gt; fileslist:&nbsp;&nbsp;&nbsp; client = BACKUP
	17:18:52.743 [980.1788] &lt;2&gt; fileslist:&nbsp;&nbsp;&nbsp; client = tpsbdc
	17:18:53.072 [4732.5180] &lt;2&gt; fileslist:&nbsp;&nbsp;&nbsp; client = tpsbdc
	17:19:41.008 [4712.4560] &lt;2&gt; fileslist:&nbsp;&nbsp;&nbsp; client = tpsbdc
	17:19:41.337 [4200.6000] &lt;2&gt; fileslist:&nbsp;&nbsp;&nbsp; client = tpsbdc
	17:26:31.554 [5212.4868] &lt;2&gt; fileslist:&nbsp;&nbsp;&nbsp; client = tpsbdc
	17:26:31.882 [1632.4396] &lt;2&gt; fileslist:&nbsp;&nbsp;&nbsp; client = tpsbdc
	18:25:02.279 [4140.4144] &lt;2&gt; fileslist:&nbsp;&nbsp;&nbsp; client = backup
	18:25:02.811 [1360.4160] &lt;2&gt; fileslist:&nbsp;&nbsp;&nbsp; client = backup
	18:25:03.404 [4120.4192] &lt;2&gt; fileslist:&nbsp;&nbsp;&nbsp; client = BACKUP
	18:25:03.904 [2544.4496] &lt;2&gt; fileslist:&nbsp;&nbsp;&nbsp; client = BACKUP
	18:25:08.389 [3768.2960] &lt;2&gt; fileslist:&nbsp;&nbsp;&nbsp; client = backup
	18:25:08.889 [4868.4804] &lt;2&gt; fileslist:&nbsp;&nbsp;&nbsp; client = backup
	18:25:09.357 [4812.4688] &lt;2&gt; fileslist:&nbsp;&nbsp;&nbsp; client = BACKUP
	18:25:09.842 [1532.1536] &lt;2&gt; fileslist:&nbsp;&nbsp;&nbsp; client = BACKUP
	18:25:42.935 [2000.4580] &lt;2&gt; fileslist:&nbsp;&nbsp;&nbsp; client = tpsbdc
	18:25:45.654 [4492.2276] &lt;2&gt; fileslist:&nbsp;&nbsp;&nbsp; client = tpsbdc
	18:28:51.603 [4596.4456] &lt;2&gt; fileslist:&nbsp;&nbsp;&nbsp; client = fileserver
	18:28:52.791 [4932.5092] &lt;2&gt; fileslist:&nbsp;&nbsp;&nbsp; client = fileserver
	18:28:53.275 [840.168] &lt;2&gt; fileslist:&nbsp;&nbsp;&nbsp; client = FILESERVER
	18:28:53.775 [4656.5332] &lt;2&gt; fileslist:&nbsp;&nbsp;&nbsp; client = FILESERVER
	18:29:02.790 [5324.5340] &lt;2&gt; fileslist:&nbsp;&nbsp;&nbsp; client = fileserver
	18:29:03.290 [5476.5500] &lt;2&gt; fileslist:&nbsp;&nbsp;&nbsp; client = fileserver
	18:29:03.790 [5612.5560] &lt;2&gt; fileslist:&nbsp;&nbsp;&nbsp; client = FILESERVER
	18:29:04.290 [5636.5600] &lt;2&gt; fileslist:&nbsp;&nbsp;&nbsp; client = FILESERVER
	18:29:25.055 [5784.5896] &lt;2&gt; fileslist:&nbsp;&nbsp;&nbsp; client = fileserver
	18:29:25.555 [5980.5984] &lt;2&gt; fileslist:&nbsp;&nbsp;&nbsp; client = fileserver
	18:29:26.039 [6056.6140] &lt;2&gt; fileslist:&nbsp;&nbsp;&nbsp; client = FILESERVER
	18:29:26.539 [6088.304] &lt;2&gt; fileslist:&nbsp;&nbsp;&nbsp; client = FILESERVER
	18:29:31.320 [3956.6128] &lt;2&gt; fileslist:&nbsp;&nbsp;&nbsp; client = fileserver
	18:29:31.836 [3852.1744] &lt;2&gt; fileslist:&nbsp;&nbsp;&nbsp; client = fileserver
	18:29:32.336 [1768.5996] &lt;2&gt; fileslist:&nbsp;&nbsp;&nbsp; client = FILESERVER
	18:29:32.836 [1336.6108] &lt;2&gt; fileslist:&nbsp;&nbsp;&nbsp; client = FILESERVER
	18:29:38.351 [1196.2248] &lt;2&gt; fileslist:&nbsp;&nbsp;&nbsp; client = tpsbdc
	18:29:38.679 [900.4128] &lt;2&gt; fileslist:&nbsp;&nbsp;&nbsp; client = tpsbdc
	18:50:46.836 [5332.5700] &lt;2&gt; fileslist:&nbsp;&nbsp;&nbsp; client = tpsbdc
	18:50:47.164 [5444.5436] &lt;2&gt; fileslist:&nbsp;&nbsp;&nbsp; client = tpsbdc
All of the above were recorded in bprd log as diffrent SQL backup list attempts.
&nbsp;
According to this section you are trying to restore to master server, right?
	MASTERSERVER TPSBKP
	CLIENT tpsbkp
	&nbsp;
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.

zahid_haseeb · Answer

i faced the below error on status view
&nbsp;
&nbsp;
# This batch file was created for an operation on host TPSBDC using
# the SQL Server instance &lt;default&gt;.
# Move this file to the Veritas\NetBackup\dbext\MSSQL\ directory
# on host &lt;TPSBDC&gt;. Execute it there using the NetBackup
# Database Extension GUI or the NetBackup Scheduler.
#&nbsp;
# &nbsp;
# &nbsp;This is a template for the database MOVE command.
# &nbsp;
OPERATION RESTORE
OBJECTTYPE DATABASE
RESTORETYPE MOVE
# &nbsp;
# &nbsp;Replace the database name in the following line with the name of the database that you
# &nbsp;want to move to. Also remove the hash mark &lt;#&gt; which precedes the keyword &lt;DATABASE&gt;.
# &nbsp;
DATABASE "trkmaster"
#&nbsp;
# &nbsp;Replace the file path &lt;E:\Live DataBases	rkmaster.mdf&gt;
# &nbsp;with a new file path. Also remove the hash mark &lt;#&gt; which precedes the keyword &lt;TO&gt;.
# &nbsp;The target of the MOVE keyword must be "trkmaster_dat".&nbsp;
MOVE &nbsp;"trkmaster_dat"
TO &nbsp;"d:\SQL	rkmaster	rkmaster.mdf"
#&nbsp;
#&nbsp;
# &nbsp;Replace the file path &lt;E:\Live DataBases	rkmaster_log.ldf&gt;
# &nbsp;with a new file path. Also remove the hash mark &lt;#&gt; which precedes the keyword &lt;TO&gt;.
# &nbsp;The target of the MOVE keyword must be "trkmaster_log".&nbsp;
MOVE &nbsp;"trkmaster_log"
TO &nbsp;"d:\SQL	rkmaster	rkmaster_log.ldf"
#&nbsp;
# 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
&nbsp;
INF - RESTORE STARTED USING
Microsoft SQL Server &nbsp;2000 - 8.00.194 (Intel X86)&nbsp;
Aug &nbsp;6 2000 00:57:48&nbsp;
Copyright (c) 1988-2000 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)&nbsp;
Batch = C:\Documents and Settings\Rep-Tps\Desktop	rkmaster2-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	rkmaster	rkmaster.mdf', move 'trkmaster_log' to 'd:\SQL	rkmaster	rkmaster_log.ldf', replace
INF - Number of stripes: 1, Number of buffers per stripe 2.
ERR - Error in CoCreateInstance: 0x80040154.
&nbsp;&nbsp; &nbsp;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	rkmaster2-12-2010.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 3(0) seconds.
INF - Results of executing &lt;C:\Documents and Settings\Rep-Tps\Desktop	rkmaster2-12-2010.bch&gt;:&nbsp;
&lt;0&gt; operations succeeded. &lt;1&gt; operations failed.
&nbsp;
&nbsp;
&nbsp;
&nbsp;
I found the TN but after following the below TN i am still facing the same error
&nbsp;
http://www.symantec.com/business/support/index?page=content&amp;id=TECH35016

marianne · Answer

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 · Answer

bprd logs

Forum Discussion

sql2000 restore is not initiating

4 Replies

Related Content

Re: ERROR: file read failed BAR when browsing for restore

BMR restore.

How to find which user initiated immediate/user-directed backup?

Report Restore

Re: How restore SQL database to different server?

Recent Discussions

"failed, status 6" error after increasing datastore (LUN) capacity

command: bperror

MS-SharePoint policy restore error (2804) .

How to restore a backup

How to configure RBAC