nb5备份sql2005的问题

squall_sw

SQL使用混合验证,NB MS SQL CLIENT里帐户使用administratr,备份数据库的时候出现如下错误,请问如何解决??

9/11/2006 12:52:18 PM - started process bpbrm (3636)
9/11/2006 12:52:18 PM - connecting
9/11/2006 12:52:18 PM - connected; connect time: 00:00:00
9/11/2006 12:52:28 PM - end writing
none of the requested files were backed up(2)
9/11/2006 12:52:28 PM - Error bpsched(pid=956) suspending further backup attempts for client netbackup, policy 1, schedule Full because it has exceeded the configured number of tries
9/11/2006 12:52:29 PM - Error bpsched(pid=956) backup of client netbackup exited with status 2 (none of the requested files were backed up)

june_cai

第一、检查备份脚本在不在
第二、检查你的备份策略是不是配置正确。
有可能的话，把备份策略贴出来看看。

squall_sw

这是脚本内容
OPERATION BACKUP
DATABASE $ALL
SQLHOST "NETBACKUP"
NBSERVER "NETBACKUP"
MAXTRANSFERSIZE 0
BLOCKSIZE 7
ENDOPER TRUE

这是设置

squall_sw

俺设置完是直接点manual backup让他马上执行,之后就出现1楼出现的错误

squall_sw

还有这个服务一直是down的!!起不来!这是为什么?

科学球

vmd和bprd起来就可以了。其他进程即使停了，也能自动重起的，不用管。

看你设置，SQL的脚本和配置看不出问题。

你把日志建起来，重新发起一次，看看日志报什么错误。

建这两个目录
install_path\NetBackup\logs\bphdb
install_path\NetBackup\logs\dbclient

还解决不了，就把日志贴上来。

squall_sw

install_path\NetBackup\logs\bphdb目录下的日志

14:05:45.812 [2072.2736] <2> logparams: -sb -rdbms sql_server -S netbackup -to 300 -c 11 -s Full -clnt netbackup -FULL -b netbackup_1157954745 -jobid 10 -shm
14:05:45.812 [2072.2736] <2> ParseConfigExA: Unknown configuration option on line 49: RenameIfExists = 0
14:05:45.812 [2072.2736] <4> bphdb: INF - BACKUP START
14:05:45.812 [2072.2736] <4> bphdb: INF - CONTINUE BACKUP message received.
14:05:45.812 [2072.2736] <4> bphdb: INF - Processing C
14:05:46.109 [2072.2736] <16> bphdb: ERR - command failed: none of the requested files were backed up (2)
14:05:46.109 [2072.2736] <16> bphdb: ERR - exit status  :  (2)
14:05:46.109 [2072.2736] <16> bphdb: ERR - bphdb exit status = 2: none of the requested files were backed up

14:05:46.109 [2072.2736] <4> bphdb: INF - EXIT STATUS 2: none of the requested files were backed up

14:05:47.515 [2956.1324] <2> logparams: -sb -rdbms sql_server -S netbackup -to 300 -c 11 -s Full -clnt netbackup -FULL -b netbackup_1157954745 -jobid 10 -shm
14:05:47.515 [2956.1324] <2> ParseConfigExA: Unknown configuration option on line 49: RenameIfExists = 0
14:05:47.515 [2956.1324] <4> bphdb: INF - BACKUP START
14:05:47.515 [2956.1324] <4> bphdb: INF - CONTINUE BACKUP message received.
14:05:47.515 [2956.1324] <4> bphdb: INF - Processing C
14:05:47.984 [2956.1324] <16> bphdb: ERR - command failed: none of the requested files were backed up (2)
14:05:47.984 [2956.1324] <16> bphdb: ERR - exit status  :  (2)
14:05:47.984 [2956.1324] <16> bphdb: ERR - bphdb exit status = 2: none of the requested files were backed up

14:05:47.984 [2956.1324] <4> bphdb: INF - EXIT STATUS 2: none of the requested files were backed up

install_path\NetBackup\logs\dbclient

14:04:27.968 [2304.2344] <2> ParseConfigExA: Unknown configuration option on line 49: RenameIfExists = 0
14:04:27.968 [2304.2344] <2> logconnections: BPRD CONNECT FROM 10.10.10.11.2474 TO 10.10.10.11.13720
14:04:27.968 [2304.2344] <2> ParseConfigExA: Unknown configuration option on line 49: RenameIfExists = 0
14:04:27.984 [2304.2344] <4> CGlobalInformation::VCSVirtualNameList: INF - Veritas Cluster Server is not installed.
14:04:27.984 [2304.2344] <1> CGlobalInformation::VCSVirtualNameList:     CONTINUATION: - The system cannot find the path specified.
14:04:27.984 [2304.2344] <4> getServerName: Read server name from nb_master_config: netbackup
14:04:27.984 [2304.2344] <4> CDBIniParms::CDBIniParms: INF - NT User is Administrator
14:04:28.015 [2304.2344] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_temp_2304_2344>, SQL userid <Administrator>.
14:04:28.078 [2304.2344] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_temp_2304_2344>, SQL userid <Administrator>.
14:04:30.078 [2304.2344] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_2304_2344>, SQL userid <Administrator>.
14:04:30.093 [2304.2344] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_2304_2344>, SQL userid <netbackup\administrator>.
14:04:30.140 [2304.2344] <4> StartupProcess: INF - Starting: <C:\Program Files\VERITAS\NetBackup\bin\admincmd\bpcllist.exe -byclient NETBACKUP>
14:04:30.156 [2304.2344] <8> CDBbackupView::ClassDropDownList: WARN - Error in StartupProcess: Command String: C:\Program Files\VERITAS\NetBackup\bin\admincmd\bpcllist.exe -byclient NETBACKUP
14:04:30.156 [2304.2344] <8> CBackupDBDlg::OnInitDialog: WARN - Policy Dropdown not created: Server = netbackup, Client = NETBACKUP
14:04:41.546 [2304.2344] <4> StartupProcess: INF - Starting: <notepad C:\1.bch>
14:04:58.015 [2304.2344] <4> StartupProcess: INF - Starting: <notepad C:\1.bch>
14:05:01.093 [2304.2344] <4> CGlobalInformation:SNCleanUp: INF - SQLDataSources did not fetch any ODBC user data source names
14:05:45.843 [1644.336] <2> ParseConfigExA: Unknown configuration option on line 49: RenameIfExists = 0
14:05:45.843 [1644.336] <2> logconnections: BPRD CONNECT FROM 10.10.10.11.2549 TO 10.10.10.11.13720
14:05:45.843 [1644.336] <2> ParseConfigExA: Unknown configuration option on line 49: RenameIfExists = 0
14:05:45.875 [1644.336] <4> CGlobalInformation::VCSVirtualNameList: INF - Veritas Cluster Server is not installed.
14:05:45.875 [1644.336] <1> CGlobalInformation::VCSVirtualNameList:     CONTINUATION: - The system cannot find the path specified.
14:05:45.875 [1644.336] <4> getServerName: Read server name from nb_master_config: netbackup
14:05:45.875 [1644.336] <4> CDBIniParms::CDBIniParms: INF - NT User is SYSTEM
14:05:45.875 [1644.336] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_1644_336>, SQL userid <SYSTEM>.
14:05:45.953 [1644.336] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_1644_336>, SQL userid <sa>.
14:05:45.968 [1644.336] <8> CDBMStype::SetDetailedType: WARN - SQL Version not recognized: <Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)

Oct 14 2005 00:33:37

Copyright (c) 1988-2005 Microsoft Corporation

Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1) >
14:05:45.968 [1644.336] <4> CDBbackcat::GetVirtualServer: INF - Accessing database instance <NETBACKUP> on server <NETBACKUP>.
14:05:45.968 [1644.336] <2> logconnections: BPRD CONNECT FROM 10.10.10.11.2555 TO 10.10.10.11.13720
14:05:46.000 [1644.336] <4> CDBbackrec::CDBbackrec: INF - Use standard backup method with policy <11>.
14:05:46.000 [1644.3512] <4> getServerName: Read server name from nb_master_config: netbackup
14:05:46.000 [1644.3512] <2> logconnections: BPRD CONNECT FROM 10.10.10.11.2560 TO 10.10.10.11.13720
14:05:46.062 [1644.3512] <16> Dbbackrec:erformNBOperation: USER - Operation inhibited by NetBackup for Microsoft SQL Server -- Support is not provided for unrecognized version of SQL Server <Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)

Oct 14 2005 00:33:37

Copyright (c) 1988-2005 Microsoft Corporation

Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1) >
14:05:46.062 [1644.3512] <4> getServerName: Read server name from nb_master_config: netbackup
14:05:46.062 [1644.3512] <2> logconnections: BPRD CONNECT FROM 10.10.10.11.2567 TO 10.10.10.11.13720
14:05:46.109 [1644.3512] <4> Dbbackrec:erform: INF - OPERATION #1 of batch C:\1.bch FAILED with status 1. Elapsed time = 0(0) seconds.
14:05:46.109 [1644.336] <4> CDBbackmain::dbbackup: INF - Results of executing <C:\1.bch>:

<0> operations succeeded. <1> operations failed.
14:05:46.109 [1644.336] <4> CGlobalInformation:SNCleanUp: INF - SQLDataSources did not fetch any ODBC user data source names
14:05:47.546 [2928.3052] <2> ParseConfigExA: Unknown configuration option on line 49: RenameIfExists = 0
14:05:47.546 [2928.3052] <2> logconnections: BPRD CONNECT FROM 10.10.10.11.2606 TO 10.10.10.11.13720
14:05:47.546 [2928.3052] <2> ParseConfigExA: Unknown configuration option on line 49: RenameIfExists = 0
14:05:47.562 [2928.3052] <4> CGlobalInformation::VCSVirtualNameList: INF - Veritas Cluster Server is not installed.
14:05:47.562 [2928.3052] <1> CGlobalInformation::VCSVirtualNameList:     CONTINUATION: - The system cannot find the path specified.
14:05:47.562 [2928.3052] <4> getServerName: Read server name from nb_master_config: netbackup
14:05:47.562 [2928.3052] <4> CDBIniParms::CDBIniParms: INF - NT User is SYSTEM
14:05:47.593 [2928.3052] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_2928_3052>, SQL userid <SYSTEM>.
14:05:47.656 [2928.3052] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_2928_3052>, SQL userid <sa>.
14:05:47.671 [2928.3052] <8> CDBMStype::SetDetailedType: WARN - SQL Version not recognized: <Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)

Oct 14 2005 00:33:37

Copyright (c) 1988-2005 Microsoft Corporation

Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1) >
14:05:47.671 [2928.3052] <4> CDBbackcat::GetVirtualServer: INF - Accessing database instance <NETBACKUP> on server <NETBACKUP>.
14:05:47.671 [2928.3052] <2> logconnections: BPRD CONNECT FROM 10.10.10.11.2612 TO 10.10.10.11.13720
14:05:47.890 [2928.3052] <4> CDBbackrec::CDBbackrec: INF - Use standard backup method with policy <11>.
14:05:47.890 [2928.3208] <4> getServerName: Read server name from nb_master_config: netbackup
14:05:47.890 [2928.3208] <2> logconnections: BPRD CONNECT FROM 10.10.10.11.2619 TO 10.10.10.11.13720
14:05:47.937 [2928.3208] <16> Dbbackrec:erformNBOperation: USER - Operation inhibited by NetBackup for Microsoft SQL Server -- Support is not provided for unrecognized version of SQL Server <Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)

Oct 14 2005 00:33:37

Copyright (c) 1988-2005 Microsoft Corporation

Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1) >
14:05:47.937 [2928.3208] <4> getServerName: Read server name from nb_master_config: netbackup
14:05:47.937 [2928.3208] <2> logconnections: BPRD CONNECT FROM 10.10.10.11.2626 TO 10.10.10.11.13720
14:05:47.984 [2928.3208] <4> Dbbackrec:erform: INF - OPERATION #1 of batch C:\1.bch FAILED with status 1. Elapsed time = 0(0) seconds.
14:05:47.984 [2928.3052] <4> CDBbackmain::dbbackup: INF - Results of executing <C:\1.bch>:

<0> operations succeeded. <1> operations failed.
14:05:47.984 [2928.3052] <4> CGlobalInformation:SNCleanUp: INF - SQLDataSources did not fetch any ODBC user data source names

june_cai

怎么会出现不能识别版本的错误呢？你先把补丁打上去看看行不行，在网上下载最新的maintance pack

科学球

不能识别数据库。

打补丁，5.0的话打到MP6，5.1打到MP4就可以了

squall_sw

非常感谢楼上各位的帮忙,我下了MP6打上后,问题解决!!NB真是神奇呀!!