SQL Server数据库备份恢复代码分享

//拷贝数据库
public String copyDatabase() {
Calendar cal=Calendar.getInstance();//使用日历类
int year=cal.get(Calendar.YEAR);//得到年
int month=cal.get(Calendar.MONTH)+1;//得到月，因为从0开始的，所以要加1
String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
String dbURL = "jdbc:sqlserver://192.168.0.9:1433;DatabaseName=bsterworkflow"; 
Connection dbConn = null;
Connection dbConn1 = null;
Statement statement=null;
Statement statement1=null;
try {
Class.forName(driverName); 
dbConn = DriverManager.getConnection(dbURL, "sa", "123456");
statement = dbConn.createStatement();
statement.executeUpdate("USE   master");
    String query;
    String name="bsterworkflow"+year+""+month;
    query= "backup database bsterworkflow to disk = 'c:\\"+name+".bak'";
    //System.out.println(query);
    statement.executeUpdate(query);
    
    //还原数据库
    String sql="use master if exists(select * from sysdatabases where name='"+name+"') drop database "+name+" create database "+name;
    statement.executeUpdate(sql); 
   
    sql="restore database "+name+" from disk = 'c:\\"+name+".bak'"+"   WITH MOVE 'bsterworkflow_Data' TO 'c:\\Program Files\\Microsoft SQL Server\\MSSQL\\Data\\"+name+".mdf', MOVE 'bsterworkflow_Log' TO 'c:\\Program Files\\Microsoft SQL Server\\MSSQL\\Data\\"+name+"_log.ldf',replace";
    //System.out.println(sql);    
    statement.executeUpdate(sql);