create a winform to backup SQL server

Question

I Guys! I have a big problem..i need to create a simple form(vb.net) to backup a couple of database in sql server. Could you please give me some code please!

panna chatterjee · Answer

You can use sql query in SqlCommand object. //C# CODE private void btnStart_Click(object sender EventArgs e) { SqlCommand cmd1 = new SqlCommand(backup database CRM to disk = 'e:\CRM.bak'con); con.Open(); cmd1.ExecuteNonQuery(); con.Close(); MessageBox.Show(BACKED UP SUCCESSFULLY); } //CRM is DATABASE NAME here

Nilesh Jadav · Answer

Hi there ! There are many awesome sources over internet you can lookup for that some of these are given below please check these sources  it might help you: 1) http://www.c-sharpcorner.com/UploadFile/rohatash/creating-sql-server-backup-file-with-C-Sharp/ 2) https://www.mssqltips.com/sqlservertip/1849/backup-and-restore-sql-server-databases-programmatically-with-smo/ Hope that helps !