Take a look at this.
string ConnectionString="Place Your ConnectionString";
public static void GenerateBackup(string DBName,string Location)
{
if (ConnectionString.Length > 0)
{
System.Data.SqlClient.SqlConnection dbConn = null;
try
{
string Query = "BACKUP DATABASE "+DBName+" TO DISK = '" + Location+ DateTime.Now.TimeOfDay.Ticks + ".bak'";
dbConn = new System.Data.SqlClient.SqlConnection(ConnectionString);
dbConn.Open();
System.Data.SqlClient.SqlCommand dbCmd = new System.Data.SqlClient.SqlCommand(Query, dbConn);
dbCmd.ExecuteNonQuery();
}
catch (Exception ex)
{
}
finally
{
if (dbConn.State.ToString().Equals("Open"))
{
dbConn.Close();
}
dbConn.Dispose();
}
}
}