求教关于sql server2000备份

[sj8397]

本人要做一个软件
要实现数据库的全备份和增量备份
备份的话是要备份到另外一个数据库内
想用java做
大侠给点提示怎么做
谢谢

[晓风残月0110]

--以下脚本执行SQL Server 中某一数据库全备份，并将备份文件传至另一机器。
--备份文件命名规则：数据库名_时间戳.BAK。

@ECHO off

REM Backup Database Script Log Files
SET dbbak_dir=e:testdbbak
if not exist %dbbak_dir% mkdir %dbbak_dir%

REM Backup Database Name
SET B_Database_Name=aa  --本地数据库名
SET B_DATE=%date:~0,4%%date:~5,2%%date:~8,2%
ECHO use master ;>%dbbak_dir%FULL_backup.sql
ECHO go >>%dbbak_dir%FULL_backup.sql
rem ECHO SP_ADDUMPDEVICE 'DISK',>>%dbbak_dir%FULL_backup.sql
rem ECHO '%B_Database_Name%_%B_DATE%_FULL', >>%dbbak_dir%FULL_backup.sql
rem ECHO '%dbbak_dir%%B_Database_Name%_%B_DATE%_FULL.bak'; >>%dbbak_dir%FULL_backup.sql
rem ECHO go >>%dbbak_dir%FULL_backup.sql
ECHO BACKUP DATABASE %B_Database_Name% >>%dbbak_dir%FULL_backup.sql
ECHO TO DISK = '%dbbak_dir%%B_Database_Name%_%B_DATE%_FULL.bak' >>%dbbak_dir%FULL_backup.sql
ECHO WITH INIT , NOUNLOAD ;>>%dbbak_dir%FULL_backup.sql
ECHO go >>%dbbak_dir%FULL_backup.sql
ECHO .

REM osql.exe path
SET OSQL_PATH=C:Program FilesMicrosoft SQL Server80ToolsBinn

REM Database user name and password
SET DBUser=sa--用户名
SET DBpassword=sa--密码
ECHO BACKUP DATABASE
"%OSQL_PATH%osql.exe" -U %DBUser% -P %DBpassword% -i %dbbak_dir%FULL_backup.sql -o %dbbak_dir%%B_Database_Name%_%B_DATE%_FULL.log


REM FTP info
set FTP_User=sa--用户名
set FTP_PW=sa  --密码
set FTP_IP=192.168.0.111 --ip
set FTP_PORT=21
set FTP_DIR=/home/dbbak

SET NCFTP_PATH=D:Program FilesNcFTP
"%NCFTP_PATH%ncftpput.exe" -u %FTP_User% -p %FTP_PW% -P %FTP_PORT% %FTP_IP% %FTP_DIR% %dbbak_dir%%B_Database_Name%_%B_DATE%_FULL.*

REM Delete old backup files
FORFILES /P %dbbak_dir% /D -7 -M %B_Database_Name%*.bak /C "cmd /c del @file"
FORFILES /P %dbbak_dir% /D -7 -M %B_Database_Name%*.log /C "cmd /c del @file"

REM Delete Temp files
DEL /Q %dbbak_dir%FULL_backup.sql