sql2000 restore is not initiating

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.