how to make Database Backup

Question

0.00/5 (No votes)

See more:

Dear All

How to Make Database Backup in sql server 2008

my database location : C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\Test.mdf

i am using command Button. When i click Command Button that time i want to store database in D:\Backup Database\Test.mdf

Please tell me.. how i do for this

Posted 18-Apr-13 5:19am

Navas Khanj

Add a Solution

Comments

ZurdoDev 18-Apr-13 11:20am

That isn't exactly a backup, but a copy. You could just use File.Copy
http://msdn.microsoft.com/en-us/library/system.io.file.aspx Otherwise, issue a SQL command to do an actual backup.

1 solution

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)

tarhex · Accepted Answer · 2013-04-18T08:54:00

VB

'backup database


        Try
            Dim backupdate, newname As String

            'backup database
            backupdate = DateString
            newname = "C:\backup\dbase" & "" + backupdate + "" & ".mdf"


            'check if a current day backup exist
            If System.IO.File.Exists(newname) Then


                'if yes, delete the former backup and backup the new one the new one

                System.IO.File.Delete(newname)
                System.IO.File.Copy(Application.StartupPath & "\db\dbase.mdf", newname)

            Else

                'backup database
                System.IO.File.Copy(Application.StartupPath & "\db\dbase.mdf", newname)


            End If

            Dim mymsg As New myMsgbox

            'show that backup is successful
            With mymsg

                .txtError.Text = "Database Backup Successful!"
                .ShowDialog()

            End With


        Catch ex As Exception

            Dim mymsg As New myMsgbox

            'show an error when backup is not successful
            With mymsg

                .txtError.Text = "Error Backing Up Database, try again later!"
                .ShowDialog()

            End With

        End Try