backup and restore گرفتن پشتیبان از دیتابیس و بازگردانی آن

[صباح فتحی]

        private void button1_Click(object sender, EventArgs e)

        {

            SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;Integrated Security=True");

            SqlCommand com=new SqlCommand();

            com.Connection = con;

            con.Open();

            com.CommandText="Use master backup database [phonebank] to disk=N'd:\\o'";

            com.ExecuteNonQuery();

            con.Close();

        }