VERITAS NBU 恢复MSSQL 7报错--5

aixdb2

mssql 7 的异地恢复，SQL SERVER打到了SP4，同样的恢复方法在SQL 2000下恢复成功了，7就是不行，气死了
恢复日志如下：
OPERATION RESTORE
OBJECTTYPE DATABASE
DATABASE "UFSystem"
NBIMAGE "djcw_nt.MSSQL7.DJCW_NT.db.UFSystem.~.0.001of001.20040524022200..C"
SQLHOST "ORACLE"
NBSERVER "SEAS"
BROWSECLIENT "djcw_nt"
MAXTRANSFERSIZE 0
BLOCKSIZE 0
RESTOREOPTION REPLACE
RECOVEREDSTATE NOTRECOVERED
ENDOPER TRUE

18:31:24 [1220,1504]     CONTINUATION: - 系统找不到指定的文件。
18:31:24 [1220,512] <4>; Dbbackrec:erformNBOperation: INF - LOAD STARTED USING
Microsoft SQL Server  7.00 - 7.00.1063 (Intel X86)
        Apr  9 2002 14:18:16
        Copyright (c) 1988-2002 Microsoft Corporatio
n
        Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

Batch = C:\Program Files\VERITAS\NetBackup\Logs\user_ops\mssql\logs\0526104183124-432-508-000-000-prg, Op# = 1.
18:31:24 [1220,512] <4>; InitPipeInfo: INF - Using backup image 'djcw_nt.MSSQL7.DJCW_NT.db.UFSystem.~.0.001of001.20040524022200..C'.
18:31:24 [1220,512] <4>; Dbbackrec:erformNBOperation: INF - restore database "UFSystem" from VIRTUAL_DEVICE='VNBU0-1220-512' with blocksize = 512, maxtransfersize = 65536, buffercount = 1, replace ,
norecovery
18:31:24 [1220,512] <4>; Dbbackrec:erformNBOperation: INF - #Stripes: 1, #Bufs per stripe 1, From: NetBackup on SEAS
Restore started Wed May 26 18:31:24 2004


18:31:26 (21769.xxx) Restore job id 21769 will require 1 image.
18:31:26 (21769.xxx) Media id 000097 is needed for the restore.

18:31:29 (21769.001) Restoring from image created Mon May 24 02:30:35 2004
18:31:32 (21769.001) INF - Media id 000097 on server seas is in use, waiting for it.
18:31:32 (21769.001) INF - Data socket = seas.2090
18:31:32 (21769.001) INF - Name socket = seas.4378
18:31:32 (21769.001) INF - Job id = 21769
18:31:32 (21769.001) INF - Backup id = djcw_nt_1085337035
18:31:32 (21769.001) INF - Backup time = 1085337035
18:31:32 (21769.001) INF - Policy name = djcw_nt
18:31:32 (21769.001) INF - Frozen image = 0
18:31:32 (21769.001) INF - Backup copy = 0
18:31:33 (21769.001) INF - Master server = seas
18:31:33 (21769.001) INF - Media server = seas
18:31:33 (21769.001) INF - New data socket = seas.4296
18:31:33 (21769.001) INF - Use shared memory = 0
18:31:33 (21769.001) INF - Restore id = 21769.001
18:31:33 (21769.001) INF - Encrypt = 0
18:31:33 (21769.001) INF - Client read timeout = 3000
18:31:33 (21769.001) INF - Media mount timeout = 0
18:31:33 (21769.001) INF - client = oracle
18:31:34 (21769.001) INF - requesting_client = oracle
18:31:34 (21769.001) INF - browse_client = djcw_nt
20:36:49 (21769.001) INF - Waiting for positioning of media id 000097 on server seas.
20:37:11 (21769.001) INF - Beginning restore from server seas to client oracle.
20:37:15 (21769.001) The following files/folders were not restored:
20:37:15 (21769.001) UTF - /djcw_nt.MSSQL7.DJCW_NT.db.UFSystem.~.0.001of001.20040524022200..C
20:37:16 (21769.001) Status of restore from image created Mon May 24 02:30:35 2004 = socket write failed

20:37:16 INF - Server status = 5
20:37:16 [1220,512] <16>; CODBCaccess::LogODBCerr: DBMS MSG - ODBC message. ODBC return code <-1>;, SQL State <37000>;, Message Text <[Microsoft][ODBC SQL Server Driver][SQL Server]The file 'C:\WF821\Adm
in\UFSystem.MDF' cannot be used by RESTORE. Consider using the WITH MOVE option to identify a valid location for the file.>;
20:37:16 [1220,512] <16>; CODBCaccess::LogODBCerr: DBMS MSG - <[Microsoft][ODBC SQL Server Driver][SQL Server]Backup or restore operation terminating abnormally.>;
20:37:16 [1220,512] <32>; Dbbackrec:erformNBOperation: ERR - Error found executing <restore database "UFSystem" from VIRTUAL_DEVICE='VNBU0-1220-512' with blocksize = 512, maxtransfersize = 65536, buf
fercount = 1, replace , norecovery>;
20:37:17 (21769.xxx) INF - Status = the restore failed to recover the requested files.

20:37:20 [1220,1552] <32>; DBthreads::dbclient: ERR - <VxBSAEndData>; failed with error <3>;. The text follows:
20:37:20 [1220,1552]     CONTINUATION: - System detected error, operation aborted.
20:37:20 [1220,512] <32>; CDBbackrec::FreeDeviceSet(): ERR - Error in VDS->;Close: 0x80770004. The text follows:
20:37:20 [1220,512]     CONTINUATION: - An abort request is preventing anything except termination actions.
20:37:20 [1220,512] <4>; Dbbackrec:erform: INF - OPERATION #1 of batch C:\Program Files\VERITAS\NetBackup\Logs\user_ops\mssql\logs\0526104183124-432-508-000-000-prg FAILED with STATUS 1 (0 is normal)
. Elapsed time = 7556(7556) seconds.
20:37:20 [1220,1504] <4>; CDBbackmain::dbbackup: INF - Results of executing <C:\Program Files\VERITAS\NetBackup\Logs\user_ops\mssql\logs\0526104183124-432-508-000-000-prg>;:
<0>; operations succeeded. <
1>; operations failed.

aixdb2

ODBC test successful

aixdb2

已经解决了。

vx1

能把经验说一下吗?