- 论坛徽章:
- 0
|
各位高手,我现在装sybase的系统和nbu软件的系统都是win2003,想请问在sybase客户端都需要做什么设置?找了好久了,都没有成功,还请大家帮帮忙哦
我在nbu服务器(名称sybase-b)端建立了本地基础磁盘作为存储单元,然后建立了策略sybase_p、建立了sybase_s备份时间日程,然后再客户端(名称sybase)的sybase里建立了脚本文件如下:
我的数据库是12.5版本,下面红色部分是我改动的内容,但是就是不成功,显示本分完成,但是没有生成文件,不知道什么原因,
@REM $Revision: 1.4 $
@REM bcpyrght
@REM **************************************************************************
@REM * $VRTScprght: Copyright 1993 - 2011 Symantec Corporation, All Rights Reserved $ *
@REM **************************************************************************
@REM ecpyrght
@setlocal
@echo off
@REM **************************************************************************
@REM Replace C:\Sybase below with your actual Sybase home directory
@REM **************************************************************************
@set SYBASE=C:\Sybase
@REM **************************************************************************
@REM Replace Sybase below with the actual name of your SQL Server
@REM **************************************************************************
@set SYBSERVER=SYBASE
@REM **************************************************************************
@REM Replace SYB_DB below with the actual name of your Sybase database
@REM **************************************************************************
@set DATABASE_NAME=TEST_JXC
if "%SYBASE_OCS%" == "" goto notsyb12
@REM ********* Sybase 12.0 or later ***********
@set OCS_QUAL=\%SYBASE_OCS%
goto cont1
:notsyb12
@REM ********* Sybase 11.9.2 or earlier **********
@set OCS_QUAL=
:cont1
@REM **************************************************************************
@REM These environment variables are set by NetBackup.
@REM **************************************************************************
@echo SYBACKUP_SERVER = %SYBACKUP_SERVER%
@echo SYBACKUP_POLICY = %SYBACKUP_POLICY%
@echo SYBACKUP_SCHED = %SYBACKUP_SCHED%
@echo SYBACKUP_CLIENT = %SYBACKUP_CLIENT%
@echo SYBACKUP_SCHEDULED = %SYBACKUP_SCHEDULED%
@echo SYBACKUP_USER_INITIATED = %SYBACKUP_USER_INITIATED%
@REM **************************************************************************
@REM Replace "database_dump" below with your actual NetBackup schedule name
@REM which is used for a full backup of the Sybase database.
@REM **************************************************************************
if "%SYBACKUP_SCHED%" == "sybase_s" goto dbdump
@REM *********** NetBackup has started a "transaction_dump" backup ***********
set DUMP_TYPE=TRANSACTION
goto entercmd
:dbdump
@REM *********** NetBackup has started a "database_dump" backup ***********
set DUMP_TYPE=DATABASE
:entercmd
@REM **************************************************************************
@REM Replace "Default-Application-Backup" below with your actual NetBackup
@REM Application Backup type schedule name for the Sybase database.
@REM **************************************************************************
@echo dump %DUMP_TYPE% %DATABASE_NAME% to "sybackup::-SERV %SYBACKUP_SERVER% -CLIENT %SYBACKUP_CLIENT% -POL %SYBACKUP_POLICY% -SCHED Default-Application-Backup -STAT_FILE %STATUS_FILE%" > .\syb_%DATABASE_NAME%_dump
@REM **************************************************************************
@REM Remove the REM from the beginning of the line below if you are going to
@REM use multiple stripes for the backup. Repeat this line for each stripe.
@REM Replace "Default-Application-Backup" below with your actual NetBackup
@REM Application Backup type schedule name for the Sybase database.
@REM **************************************************************************
@REM echo stripe on "sybackup::-SERV %SYBACKUP_SERVER% -CLIENT %SYBACKUP_CLIENT% -POL %SYBACKUP_POLICY% -SCHED Default-Application-Backup -STAT_FILE %STATUS_FILE%" >> .\syb_%DATABASE_NAME%_dump
@echo go >> .\syb_%DATABASE_NAME%_dump
@REM **************************************************************************
@REM Log the isql command. This line may appear in NetBackup log files.
@REM Do NOT replace "xxxxxxxx" with a user id or password.
@REM **************************************************************************
set PRT_LINE=%SYBASE%%OCS_QUAL%\bin\isql -Uxxxxxxxx -Pxxxxxxxx -I%SYBASE%\ini\sql.ini -S%SYBSERVER% -i .\syb_%DATABASE_NAME%_dump
@echo %PRT_LINE%
@REM **************************************************************************
@REM Replace "sa" with your Sybase server Administrator's login name.
@REM Replace "manager" with your Sybase server Administrator's password.
@REM **************************************************************************
set CMD_LINE=%SYBASE%%OCS_QUAL%\bin\isql -Usa -P12345678 -I%SYBASE%\ini\sql.ini -S%SYBSERVER% -i .\syb_%DATABASE_NAME%_dump
%CMD_LINE%
@set RSTAT=%ERRORLEVEL%
@set STATUS_MESSAGE=completed successfully
@REM **************************************************************************
@REM This script will return an error status back to the NetBackup client if
@REM the isql command fails.
@REM **************************************************************************
if %RSTAT% NEQ 0 set STATUS_MESSGAGE=failed
echo Execution of isql command %STATUS_MESSAGE% - exiting
if exist "%STATUS_FILE%" echo %RSTAT% > "%STATUS_FILE%"
@echo on
@endlocal
不知道还需要修改什么部分,还请各位给指点一下?兄弟感激不尽! |
|