sql server 2000 DataBase Backup

[Yathish hatter]

Help me to take sql server 2000 database backup using VS.net 2008 using C# code.

[Manas Bhardwaj]

0.33 seconds of google search gave me these [^]results

Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

[Satish Pai]

Hi This Code might help you. we have to create 2 textbox 1 of name - dbName textbox 2 of name - txtLocation private void button1_Click(object sender, EventArgs e) { SqlCommand cmm = new SqlCommand(); SqlConnection cn = new SqlConnection("server=.;database=" + dbName.Text + ";user=sa;password=tiger123"); cn.Open(); cmm.CommandText = "BACKUP DATABASE " + dbName.Text + " TO DISK = N'" + txtLocation.Text + "\\Intermidiate_backup_200905291809.bak' WITH NOFORMAT, NOINIT, NAME = N'Intermidiate_backup_20090529180939', SKIP, REWIND, NOUNLOAD, STATS = 10"; cmm.CommandType = CommandType.Text; cmm.Connection = cn; cmm.ExecuteNonQuery(); } Thanks & regards Satish Pai B

[Lost User]

public static void BackupDatabase(string DataBaseName , string Backupfile , string Description )
{
SqlCmd = new SqlCommand("BACKUP DATABASE @DataBaseName TO DISK = @Backupfilepath WITH INIT , DESCRIPTION = @Description", SqlCon);
SqlCmd.Parameters.AddWithValue("@DataBaseName", DataBaseName);
SqlCmd.Parameters.AddWithValue("@Backupfilepath", Backupfile);
SqlCmd.Parameters.AddWithValue("@Description", Description);
SqlCmd.ExecuteNonQuery();

    }

I know nothing , I know nothing ...