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();
} |
