How we can take the backup of server side hosted database

Question

please tell me any one how we can take the backup of server side hosted database.

Nilesh Sawardekar · Answer

Go to management studio and and then right click on your database click on task and then backup. to do all this from c# code, have a look on following, using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Diagnostics; using System.Data.SqlClient; namespace SQLBackUpApp { public partial class Form1:Form { SqlConnectioncon; SqlCommandcmd; SqlDataReaderdr; public Form1() { InitializeComponent(); } private void Form1_Load( object sender,EventArgse) { label3.Visible= false ; serverName( "." ); } public void serverName( string str) { con= new SqlConnection( "DataSource=" +str+ ";Database=Master;datasource=.;uid=sa;pwd=Micr0s0ft;" ); con.Open(); cmd= new SqlCommand( "select*fromsysserverswheresrvproduct='SQLServer'" ,con); dr=cmd.ExecuteReader(); while (dr.Read()) { ComboBoxserverName.Items.Add(dr[2]); } dr.Close(); } public void Createconnection() { con= new SqlConnection( "DataSource=" +(ComboBoxserverName.Text)+ ";Database=Master;datasource=.;uid=sa;pwd=Micr0s0ft;" ); con.Open(); ComboBoxDatabaseName.Items.Clear(); cmd= new SqlCommand( "select*fromsysdatabases" ,con); dr=cmd.ExecuteReader(); while (dr.Read()) { ComboBoxDatabaseName.Items.Add(dr[0]); } dr.Close(); } public void query( string que) { //ERROR:NotsupportedinC#:OnErrorStatement cmd= new SqlCommand(que,con); cmd.ExecuteNonQuery(); } public void blank( string str) { if ( string .IsNullOrEmpty(ComboBoxserverName.Text)| string .IsNullOrEmpty(ComboBoxDatabaseName.Text)) { //label3.Visible=true; MessageBox.Show( "ServerName&DatabasecannotbeBlank" ); return ; } else { if (str== "backup" ) { SaveFileDialog1.FileName=ComboBoxDatabaseName.Text; SaveFileDialog1.ShowDialog(); string s= null ; s=SaveFileDialog1.FileName; query( "Backupdatabase" +ComboBoxDatabaseName.Text+ "todisk='" +s+ "'" ); label3.Visible= true ; label3.Text= "DatabaseBackUphasbeencreatedsuccessful" ; } } } private void cmbbackup_Click( object sender,EventArgse) { blank( "backup" ); } private void cmbserver_SelectedIndexChanged( object sender,EventArgse) { Createconnection(); } } }

Rajeev Punhani · Answer

Hi Sudheer, Please connect the database using sql server and follow the following steps. You can do it with SQL Server Management Studio. Here are the steps - Right-click your database. Select Tasks > Generate Scripts... Introduction Step. Click Next. Choose Objects. Select entire database or selected objects. Click Next. Set Scripting Options. Here's the key step. In order to get all data and objects, click the Advanced button. Then in the Advanced Scripting Options , set the value for Types of data to script to Schema and data . Click OK. Then Next and Finish. You will have a script file that contains both database schema and data. If the above solution is helpful then, accept the answer.

How we can take the backup of server side hosted database

Answers (2)