public ActionResult restoreazuredata()
{
string dbName = Txtdbnmae.Text;
string backup = @"CREATE
DATABASE [" + dbName + "] AS COPY OF [SatyaMetaData]";// SatyaMetaData Means
Exiting Database
SqlConnection myConn = new SqlConnection("data
source=tcp:satya.database.windows.net,1445;persist security info=True;user
id=satyauser;password=satyas46;database=master");//Your Connection Connection String
try
{
SqlCommand cmd = new SqlCommand(backup, myConn);
myConn.Open();
cmd.CommandTimeout = 10000;
cmd.ExecuteNonQuery();
myConn.Close();
return Json("1");
}
catch
{
return Json("0");
}
}
No comments:
Post a Comment