Sqlserver2000 backup database

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.exe cutequery (qrysql );
While (Rs. Next ()){
If (Rs. getint ("CNT")> 0 ){
String SQL = "use master exec sp_dropdevice \ 'backupbank \'";
Preparedstatement pstmt = dB. getcon (). preparestatement (SQL );
Pstmt.exe cuteupdate ();
}
}

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.exe cuteupdate ();
} Catch (exception e ){
E. printstacktrace ();
Return false;
}
Return true;
}

Use master

Exec sp_addumpdevice 'disk', 'backupban', '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'