eclipse tomcat sql2000的环境 想学习一下sql2000数据库源文件的备份下面一段代码 怎么修改 才能实现 将 sql2000数据库源文件(dbps_Data 和 dbps_Log) 备份到 C:\ 呢?java类 (Backup.java)public class Backup extends ActionSupport {
public String execute() throws Exception {
Runtime r=Runtime.getRuntime();
r.exec("cmd /c backup database dbps TO DISK='C:\'");
msg = "备份成功!";
return SUCCESS;
}jsp页面 ... ...
function sub(i) {
if(i==1) document.f.submit();
}
... ...
<s:form name="f" action="Backup" theme="simple">
... ...
<tr>
<td width="500" align="center" colspan="5" valign="middle" height="35" bgcolor="2C5783">
<s:submit type="submit" value="备份" onclick="sub(1)" align="center" style="width:160px;height:30px"/></td>
</tr>
.
public String execute() throws Exception {
Runtime r=Runtime.getRuntime();
r.exec("cmd /c backup database dbps TO DISK='C:\'");
msg = "备份成功!";
return SUCCESS;
}jsp页面 ... ...
function sub(i) {
if(i==1) document.f.submit();
}
... ...
<s:form name="f" action="Backup" theme="simple">
... ...
<tr>
<td width="500" align="center" colspan="5" valign="middle" height="35" bgcolor="2C5783">
<s:submit type="submit" value="备份" onclick="sub(1)" align="center" style="width:160px;height:30px"/></td>
</tr>
.
--备份和还原
--1、直接备份到文件
BACKUP DATABASE sales TO DISK='F:\BACKDB.dat'
--2、通过备份设备(逻辑的)
sp_addumpdevice 'disk', mybackdevice ,'F:\BACKDB.bak'sp_dropdevice mybackdeviceBACKUP DATABASE sales TO mybackdevice
--恢复
RESTORE DATABASE sales FROM mybackdevice
你这里少了备份文件名,加一个就可以了如:
r.exec("cmd /c backup database dbps TO DISK='C:\test.mdf'");