Click here to Skip to main content
15,887,485 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi..I have 1 Web Site and i have backup database on web site in my application..
How to possible ???
Posted

Create a database backup script and execute it.

C#
// You'll need to read a little bit about how this query works.
// It's a lot of different ways of doing this. This is an example:
string sql = "BACKUP DATABASE [SQL Database] TO DISK = 'D:\SQLDatabase.bak'";
SqlConnection cn = new SqlConnection("connectionstring");
SqlCommand cmd = new SqlCommand(sql, cn);
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
 
Share this answer
 
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900