How to take backup of sql server 2005 database in c#.net without SMO

Question

1.00/5 (1 vote)

See more:

C#

SQL

server

How to take backup of sql server 2005 database in c#.net without SMO

Posted 1-Aug-13 19:59pm

veenusethi

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)

Mehdi Gholam · Answer 1 · 2013-08-01T21:28:00

Solution 1

Read the following :
http://technet.microsoft.com/en-us/library/ms187510.aspx#TsqlProcedure[^]

http://technet.microsoft.com/en-us/library/ms186865.aspx[^]

Posted 1-Aug-13 21:28pm

Mehdi Gholam

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Answer 2 · 2013-08-01T22:10:00

Solution 2

Follow -

1. SQL Server 2005 Database Backup and Restore using C#.NET 2.0[^].
2. SQL Server 2005 Database Backup and Restore using C# and .NET 2.0[^].

Posted 1-Aug-13 22:10pm

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

Comments

veenusethi 2-Aug-13 4:30am

I want Without SMO I don't Know What is SMO and i could not find SMO dll in my pc Sol _Please Help me Database backup of sql server 2005 on button click in c#

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 2-Aug-13 5:09am

I guess without SMO you can't do it.
And for SMO, you need to to have the SQL Server Management Studio.

SMO -> SQL Server Management Objects.
For one example, refer - Create a Visual C# SMO Project in Visual Studio .NET.

codejet · Answer 3 · 2013-08-05T03:38:00

Here is a procedure is use for back up in C#.Hope it helps

C#

public  void PerformBackUp(string BackUpLocation, string BackUpFileName, string DatabaseName, string ServerName)
       {
           DatabaseName = "[" + DatabaseName + "]";
           string fileUNQ = DateTime.Now.Day.ToString() + "_" + DateTime.Now.Month.ToString() + "_" + DateTime.Now.Year.ToString() +"_"+ DateTime.Now.Hour.ToString()+ DateTime.Now .Minute .ToString () + "_" + DateTime .Now .Second .ToString () ;
           BackUpFileName = BackUpFileName + fileUNQ + ".bak";
           string SQLBackUp = @"BACKUP DATABASE " + DatabaseName + " TO DISK = N'" + BackUpLocation + @"\" + BackUpFileName + @"'";
           // Declare sqlconn,sqlcmd, show progresss execute non query
           string svr = "Server=" + ServerName + ";Database=master;Integrated Security=True";
           SqlConnection cnBk = new SqlConnection(svr);
           SqlCommand cmdBkUp = new SqlCommand(SQLBackUp, cnBk);

           try
           {
               cnBk.Open();
               cmdBkUp.ExecuteNonQuery();
               string msg = "Database " + DatabaseName + " successfully backed up to " + BackUpLocation + @"\" + BackUpFileName
                   + "\n Back Up Date : " + DateTime.Now.ToString();
               MessageBox .Show(msg,Application .ProductName , MessageBoxButtons .OK, MessageBoxIcon .Information );
               lblProgress.Visible = false;
               progressBar1.Visible = false;
           }
           catch (Exception ex)
           {
               MessageBox.Show("Database " + DatabaseName + "back up error.\n" + ex.Message, "Back Up Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
           }

           finally
           {
               if (cnBk.State == ConnectionState.Open)
               {

                   cnBk .Close();
               }
           }
       }