با کد زیر میتونی بک آپ بگیری :


            String Strbackup1,Strbackup2;

            DateTime dteDate;

            dteDate = DateTime.Now;



            Strbackup1 = "backup.bak";

            Strbackup2 = Application.StartupPath + @"\backup\" ;



            saveFileDialog1.FileName = Strbackup2 + Strbackup1 ;

            saveFileDialog1.InitialDirectory = Strbackup2;

            saveFileDialog1.ShowDialog();



            textBox1.Text = saveFileDialog1.FileName;



            System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(@"backup database tel to disk = '" + @textBox1.Text.ToString() + "'");

            //System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(@"backup database AccSlick1 to disk = 'd:\a.bak'");

            System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection(DataBase.cn);

            cmd.Connection = con ;

            con.Open();

            cmd.ExecuteNonQuery();



            this.Close();


اینم کد بازیابی اطلاعات :
openFileDialog1.Title = "بازيابي اطلاعات";

            openFileDialog1.FileName = "*.bak";

            openFileDialog1.InitialDirectory = Application.StartupPath.ToString() + @"\backup\";

            openFileDialog1.ShowDialog();

            textBox1.Text = openFileDialog1.FileName;



            //System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(@"ALTER DATABASE AccSlick1 SET SINGLE_USER with ROLLBACK IMMEDIATE; RESTORE DATABASE AccSlick1  FROM disk = " + @textBox1.Text.ToString() + " with REPLACE;ALTER DATABASE AccSlick1 SET MULTI_USER");

            System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(@"ALTER DATABASE tel SET SINGLE_USER with ROLLBACK IMMEDIATE; use [master]; RESTORE DATABASE tel  FROM disk = '" + @textBox1.Text.ToString() + "' with REPLACE;ALTER DATABASE tel SET MULTI_USER");



            //System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(@"use [master]; RESTORE DATABASE AccSlick1  FROM disk = 'G:\\a.bak' with REPLACE;");



            //System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection("Data Source=.;Initial Catalog=master;user=sa;PWD=1234");

            System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection(DataBase.cn);

            cmd.Connection = con;

            con.Open();

            cmd.ExecuteNonQuery();

            this.Close();