how to restore backup data using asp.net

krish sin

protected void Button2_Click(object sender, EventArgs e)

{

try

{

con.ConnectionString = ("Data Source=SYSTEM-6-PC;Initial Catalog=Master;Integrated Security=True");

con.Open();

string test = "D:\\backupdb\\05012017_130700.Bak";

sqlcmd = new SqlCommand("Restore database EmpolyeeTable from disk='D:\\backupdb\\05012017_130700.Bak'", con);

sqlcmd.ExecuteNonQuery();

Response.Write("restore database successfully");

}

catch (Exception ex)

{

Response.Write("Error During backup database!");

}

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Khaja Moizuddin9y ago
http://www.c-sharpcorner.com/blogs/backup-and-restore-the-database-in-asp-net-web-application2 https://www.codeproject.com/questions/538779/howplustoplusrestoreplusdatabaseplusbackupplusinpl http://www.dotnetfunda.com/articles/show/489/backup-and-restore-database-in-aspnet http://stackoverflow.com/questions/31556083/backup-and-restore-sql-database-by-admin-user-in-asp-net-c-sharp Try this
Bikesh Srivastava9y ago
This one is best article .
http://www.c-sharpcorner.com/blogs/backup-and-restore-the-database-in-asp-net-web-application2
Dr.Ajay Kashyap9y ago
http://www.dotnetfunda.com/articles/show/489/backup-and-restore-database-in-aspnet
Chetan Ranpariya9y ago
Hi Krish,

Are you getting any error when you run your code?

What error you are encountering?

Thanks and regards,
Chetan Ranpariya