前段时间做了个项目,需要用到Sql Server2000数据库,使用了T-SQL来实现数据库的备份和恢复,总结一下:
java调用T-SQL备份数据库:
备份数据库很简单,主要使用了改语句 String sql = "backup database " + dbName + " to disk = '" + bakupname + "'";
由于数据库操作要求安全性,所以该语句放在了hibernate的回调函数里,具体代码参考如下:
public Object doInHibernate(Session session)
throws HibernateException, SQLException {
conn = session.connection();
stmt = conn.createStatement();
this.backupDb(path, bakupname, fileName);
return null;
}
private void backupDb(String path, String bakupname,
String fileName) {
try {
String sql = "backup database " + dbName
+ " to disk = '" + bakupname + "'";