sqlserver2000備份資料庫

     public boolean bankUpDataBase(String filePath) throws Exception{
      DBManager db = DBManager.getInstance();
      String qrySQL = " USE master select Count(phyname) cnt from   master..sysdevices   where   name= \'backupBank\'  ";
      ResultSet rs =  db.executeQuery(qrySQL);
      while(rs.next()){
       if (rs.getInt("cnt")>0){
        String sql = "USE master exec sp_dropdevice \'backupBank\' ";
        PreparedStatement pstmt = db.getCon().prepareStatement(sql);
           pstmt.executeUpdate();
       }
      }
   
      String SQL = "USE master  "+
                   "EXEC sp_addumpdevice \'disk\', \'backupBank\',\'"+ filePath+ "\'  "+
                   "BACKUP DATABASE bank TO backupBank ";
     try{
       File file = new File(filePath);
          if(file.exists()){
           file.delete();
          }
       PreparedStatement pstmt = db.getCon().prepareStatement(SQL);
       pstmt.executeUpdate();
     }catch (Exception e){
      e.printStackTrace();
      return false;
     }
     return true;
     }

USE master

 EXEC sp_addumpdevice 'disk', 'backupBank','d:\backup\bank.dat'

 BACKUP DATABASE bank TO backupBank

USE master
select Count(phyname)   from   master..sysdevices   where   name= 'backupBank'

USE master
exec sp_dropdevice 'backupBank'