//end //---------------------------------------------------------------- public void BackUpDb(string fileName, string filePath) { string sqlBackup = "BACKUP DATABASE [" + fileName + "] TO DISK='" + filePath + "'"; ClsConnectLocal cnn = new ClsConnectLocal(); cnn.ClsConnect(); cnn.UpdateDataText(sqlBackup); cnn.DongKetNoi(); }
public void RestoreDb(string fileName, string filePath) { string sqlRestore = "Use master Restore Database [" + fileName + "] from DISK='" + filePath + "'"; string drop = "drop database " + fileName; ClsConnectLocal cnn = new ClsConnectLocal(); cnn.ClsConnect(); cnn.UpdateDataText(drop); cnn.UpdateDataText(sqlRestore); cnn.DongKetNoi(); }