Sql server Backup

Hi try this link, this will not required any shared location, it will copy the database directly to your destination server.

 

http://www.c-sharpcorner.com/UploadFile/4b43b4/copy-database-from-one-server-to-another-server-in-sql/

http://www.codeproject.com/Tips/873677/SQL-Server-Database-Backup-and-Restore-in-Csharp

 

http://www.c-sharpcorner.com/UploadFile/rohatash/creating-sql-server-backup-file-with-C-Sharp/

Hi Rashmi Saini ,

 

Go through below link-

 

http://www.c-sharpcorner.com/UploadFile/rohatash/creating-sql-server-backup-file-with-C-Sharp/ 

 

 

http://www.codeproject.com/Tips/461494/Backing-up-an-SQL-Database-in-Csharp 

Hi,

 

Auto backup : https://www.youtube.com/watch?v=PxRfzO7MCwA 

you can backup database from sql

 

choose database>right click>Task>backup

 

or you can download bak file from website panel(cpanel) to your drive as well as to ftp path.

 

And one method you can generate script of your database with data and schema.

Hi Rashmi ,

 

Use the following code

 

DateTime backupTime = DateTime.Now;
int year = backupTime.Year;
int month = backupTime.Month;

int day = backupTime.Day;
string hour = Convert.ToString(backupTime.Hour) + ".";

string minute = Convert.ToString(backupTime.Minute) + ".";
string second = Convert.ToString(backupTime.Second);

string constring = "Datasource=xxxx;port=xxxx;Database=xxxx_erp;Integrated Security=true;uid=xxxx_xxx;pwd=xxxx;convert zero datetime=True";

// var dir = @"\\Backup\\"; // folder location

var dir = Server.MapPath("Backup");


if (!Directory.Exists(dir)) // if it doesn't exist, create
Directory.CreateDirectory(dir);

using (MySqlConnection conn = new MySqlConnection(constring))
{
using (MySqlCommand cmd = new MySqlCommand())
{
cmd.CommandText="";


using (MySqlBackup mb = new MySqlBackup(cmd))
{
cmd.Connection = conn;
conn.Open();
fpath = "SomethingPath.sql"


mb.ExportToFile(dir + fpath);



conn.Close();
}
}
}