Sql server Backup

Question

Is there any free tool with which we can take backup of database fromremote server to my local machine?

I have already checked for SQLBACKUPANDFTP and SQLBACKUPMASTER but they need shared location of hosted machine... But I need some Thing that can backup on local machine without shared location.?

Upendra Pratap Shahi · Answer

Use this tool https://www.fida.org/gc.aspx?p=1001&p1=7

Upendra Pratap Shahi · Answer

Thanks Rashmi Saini for appreciation.

Khan Abrar Ahmed · Answer

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/

Rashmi Saini · Answer

Please read Question carefully.. I am not asking for Backup of same machine..I need to take Backup of Remote server from local machine .. So I need a tool .. I don't have direct access to that machine..

Abrar Ahmad Ansari · Answer

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/

Upendra Pratap Shahi · Answer

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

Rajeesh Menoth · Answer

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

Khargesh Rajput · Answer

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.

Munesh Sharma · Answer

For backup no need of any tool you right click on database .. there is an option for backup. you can use that

Shailesh Uke · Answer

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(); } } }