How we can take the backup of server side hosted database

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,

usingSystem;
usingSystem.Collections.Generic;
usingSystem.ComponentModel;
usingSystem.Data;
usingSystem.Drawing;
usingSystem.Linq;
usingSystem.Text;
usingSystem.Windows.Forms;
usingSystem.Diagnostics;
usingSystem.Data.SqlClient;
namespaceSQLBackUpApp
{
publicpartialclassForm1:Form
{
SqlConnectioncon;
SqlCommandcmd;
SqlDataReaderdr;
publicForm1()
{
InitializeComponent();
}
privatevoidForm1_Load(objectsender,EventArgse)
{
label3.Visible=false;
serverName(".");
}
publicvoidserverName(stringstr)
{
con=newSqlConnection("DataSource="+str+";Database=Master;datasource=.;uid=sa;pwd=Micr0s0ft;");
con.Open();
cmd=newSqlCommand("select*fromsysserverswheresrvproduct='SQLServer'",con);
dr=cmd.ExecuteReader();
while(dr.Read())
{
ComboBoxserverName.Items.Add(dr[2]);
}
dr.Close();
}
publicvoidCreateconnection()
{
con=newSqlConnection("DataSource="+(ComboBoxserverName.Text)+";Database=Master;datasource=.;uid=sa;pwd=Micr0s0ft;");
con.Open();
ComboBoxDatabaseName.Items.Clear();
cmd=newSqlCommand("select*fromsysdatabases",con);
dr=cmd.ExecuteReader();
while(dr.Read())
{
ComboBoxDatabaseName.Items.Add(dr[0]);
}
dr.Close();
}
publicvoidquery(stringque)
{
//ERROR:NotsupportedinC#:OnErrorStatement
cmd=newSqlCommand(que,con);
cmd.ExecuteNonQuery();
}
publicvoidblank(stringstr)
{
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();
strings=null;
s=SaveFileDialog1.FileName;
query("Backupdatabase"+ComboBoxDatabaseName.Text+"todisk='"+s+"'");
label3.Visible=true;
label3.Text="DatabaseBackUphasbeencreatedsuccessful";
}
}
}
privatevoidcmbbackup_Click(objectsender,EventArgse)
{
blank("backup");
}
privatevoidcmbserver_SelectedIndexChanged(objectsender,EventArgse)
{
Createconnection();
}
}
}

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.

2 Replies

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

Nilesh Sawardekar10y ago
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,
usingSystem;
usingSystem.Collections.Generic;
usingSystem.ComponentModel;
usingSystem.Data;
usingSystem.Drawing;
usingSystem.Linq;
usingSystem.Text;
usingSystem.Windows.Forms;
usingSystem.Diagnostics;
usingSystem.Data.SqlClient;
namespaceSQLBackUpApp
{
publicpartialclassForm1:Form
{
SqlConnectioncon;
SqlCommandcmd;
SqlDataReaderdr;
publicForm1()
{
InitializeComponent();
}
privatevoidForm1_Load(objectsender,EventArgse)
{
label3.Visible=false;
serverName(".");
}
publicvoidserverName(stringstr)
{
con=newSqlConnection("DataSource="+str+";Database=Master;datasource=.;uid=sa;pwd=Micr0s0ft;");
con.Open();
cmd=newSqlCommand("select*fromsysserverswheresrvproduct='SQLServer'",con);
dr=cmd.ExecuteReader();
while(dr.Read())
{
ComboBoxserverName.Items.Add(dr[2]);
}
dr.Close();
}
publicvoidCreateconnection()
{
con=newSqlConnection("DataSource="+(ComboBoxserverName.Text)+";Database=Master;datasource=.;uid=sa;pwd=Micr0s0ft;");
con.Open();
ComboBoxDatabaseName.Items.Clear();
cmd=newSqlCommand("select*fromsysdatabases",con);
dr=cmd.ExecuteReader();
while(dr.Read())
{
ComboBoxDatabaseName.Items.Add(dr[0]);
}
dr.Close();
}
publicvoidquery(stringque)
{
//ERROR:NotsupportedinC#:OnErrorStatement
cmd=newSqlCommand(que,con);
cmd.ExecuteNonQuery();
}
publicvoidblank(stringstr)
{
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();
strings=null;
s=SaveFileDialog1.FileName;
query("Backupdatabase"+ComboBoxDatabaseName.Text+"todisk='"+s+"'");
label3.Visible=true;
label3.Text="DatabaseBackUphasbeencreatedsuccessful";
}
}
}
privatevoidcmbbackup_Click(objectsender,EventArgse)
{
blank("backup");
}
privatevoidcmbserver_SelectedIndexChanged(objectsender,EventArgse)
{
Createconnection();
}
}
}
Rajeev Punhani10y ago
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.