How to backup and restore sql database by c# code.

Question

1.00/5 (1 vote)

See more:

How can i create the backup of sql database by c# code. Any sample code.

I am using this command to backup,it' snot working.

cmd.CommandText = @"backup database tryDatabase.mdf to disk ='d:\BackUp1.bak' with init,stats=10 ";

Posted 1-Oct-12 9:09am

footballpardeep

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

OriginalGriff · Answer 1 · 2012-10-01T09:13:00

Solution 1

Have a look here: Backing up an SQL Database in C#[^]

Posted 1-Oct-12 9:13am

OriginalGriff

Comments

footballpardeep 1-Oct-12 15:34pm

Thanks for reply, i don't want to use any dll for this. i wanna do it by sql command.

footballpardeep 1-Oct-12 16:03pm

I was not using initial catalog in connection string.
when i used this:
string connectionString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\PARDEEP\Documents\Visual Studio 2010\Projects\TryingDatabaseInWPF\TryingDatabaseInWPF\tryDatabase.mdf;Initial Catalog=tryDatabase;Integrated Security=True;User Instance=True";

It worked.

footballpardeep 1-Oct-12 16:04pm

But now the problem is how can i restore the database.

♥…ЯҠ…♥ · Answer 2 · 2013-04-29T18:53:00

Solution 3

Hi footballpardeep,

Why you didnt ask google about it?
I hope this link[^] would help you a bit.

Regards,
RK

Posted 29-Apr-13 18:53pm

♥…ЯҠ…♥

v2

Hemant L Patil · Answer 3 · 2014-11-28T00:48:00

1 Back up

OpenFileDialog ofd = new OpenFileDialog();
SaveFileDialog sfd = new SaveFileDialog();
CashFlowDAL cfd = new CashFlowDAL();
string filepath;
if (!Directory.Exists("C:\\"))
{
filepath = "C:\\BACKUP\\" + User.compname;
}
else
{
filepath = "E:\\BACKUP\\" + User.compname;
}
string res = "";

{
if (!Directory.Exists(filepath))
{
Directory.CreateDirectory(filepath);
}
try
{

string filename = DateTime.Now.ToString(User.compname + " dd_MM_yy__hh_mm_ss.bak");
res = cfd.BackupDatabase(User.compname, filepath + "\\" + filename);
if (res != null) throw new Exception(res);
File.Copy(filepath + "\\" + filename, User.backupdir + "\\" + filename);
MessageBox.Show("Backup Completed..(In " + filepath + "\\" + filename + ")");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}

2 Restore

try
{
CashFlowDAL cfd = new CashFlowDAL();
cfd.ConnectToDB();
OpenFileDialog od = new OpenFileDialog();
od.Filter = "SQL Server database Restore files|*.bak";
od.Title = "Restore Database Backup";
if (od.ShowDialog() == DialogResult.OK)
{
this.Cursor = Cursors.WaitCursor;

string UseMaster = "USE master";
SqlCommand UseMasterCommand = new SqlCommand(UseMaster, cfd.con);
UseMasterCommand.ExecuteNonQuery();

string Alter1 = @"ALTER DATABASE [" + User.compname + "] SET Single_User WITH Rollback Immediate";
SqlCommand Alter1Cmd = new SqlCommand(Alter1, cfd.con);
Alter1Cmd.ExecuteNonQuery();

string Restore = string.Format("Restore database [" + User.compname + "] from disk='{0}'", od.FileName);

SqlCommand RestoreCmd = new SqlCommand(Restore, cfd.con);
RestoreCmd.ExecuteNonQuery();

string Alter2 = @"ALTER DATABASE [" + User.compname + "] SET Multi_User";
SqlCommand Alter2Cmd = new SqlCommand(Alter2, cfd.con);
Alter2Cmd.ExecuteNonQuery();
MessageBox.Show("Database Retored Sucessfully", "Success Message!");
}
}
catch (Exception)
{
MessageBox.Show("Database didn't Restore", "Error Message!");
}
this.Cursor = Cursors.Default;