Sichern einer MS-SQLServer Datenbank aus C#

1
2
3
4
5
6
7
8

using (SqlConnection con = new SqlConnection("CONNECTION STRING"))
            {
                con.Open();
                String sql = @"BACKUP DATABASE [DATABASENAME] TO DISK = 'C:\BACKUP\DATABASENAME.BAK'";
                SqlCommand cmd = new SqlCommand(sql, con);
                cmd.CommandTimeout = 10000;
                cmd.ExecuteNonQuery();
            }