1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
| // BACKUP
cmdString = "BACKUP DATABASE [DB" + thedos + "] TO DISK = N'\\\\JUPITER\\J$\\Backup." + cbInstanceSource.Text + "\\DB" + thedos + ".bak' WITH NOFORMAT, INIT, NAME = N'DB" + thedos + "-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10";
write2dbgFile(Environment.NewLine + cmdString + Environment.NewLine);
SqlCommand sqlCmd = new SqlCommand(cmdString, connSource);
//sqlCmd.CommandTimeout = 100;
try
{
sqlCmd.ExecuteNonQuery();
}
catch (Exception e)
{
Console.WriteLine("Erreur n° {0} lors du BACKUP de {1}", e.ToString(), thedos);
MessageBox.Show("Erreur n° " + e.ToString() + " lors du BACKUP de " + thedos);
break;
}
finally
{
//sqlCmd.Close();
} |
Partager