public static void RestoreDatabase2(string strAddress)
{
string ConStr = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirector y|\DataBeh.MDF;Integrated Security=True;User Instance=true";
SqlConnection con1 = new SqlConnection(ConStr);
SqlCommand com1 = new SqlCommand();
if (con1.State != ConnectionState.Open)
con1.Open();
com1.Connection = con1;
com1.CommandText = "ALTER DATABASE ["+Application.StartupPath + "\\DataBeh.MDF] SET SINGLE_USER WITH ROLLBACK IMMEDIATE USE master RESTORE DATABASE [" + Application.StartupPath + "\\DataBeh.MDF] FROM DISK = N'" + strAddress + "' WITH FILE=1 , NOUNLOAD,REPLACE, STATS=10";
com1.ExecuteNonQuery();
con1.Close();
}
conection String رو با برنامه خودت تغییر بده :)