Click here to Skip to main content
65,938 articles
CodeProject is changing. Read more.
Articles / database / SQL-Server

SqlServer2000 Backup Control

1.80/5 (3 votes)
24 Sep 2008CPOL 1   228  
This control will allow user to backup SqlServer

Full_Image.jpg

Introduction

This control will allow user to backup SQLServer2000

Background

First time I have problem to make utility for SQLServer2000 Backup.
After reading no of articles i finally made a form for this purpose

But while i started work on my next project i again find problem and i solve it by copy-Paste my existing code and controls to new form.
Then i decided to prepare a user control for this purpose. Now its easy to drag and drop this control on my required form.

Using the code

First make a property for connection string.

Public Property ConnectionString() As String
    Get
        Return _ConnectionString
    End Get
    Set(ByVal value As String)
        _ConnectionString = value
    End Set
End Property        
<p>Write following code on button click event </p>

<pre>Try
    Dim conn As New OleDbConnection(_ConnectionString) 
    Dim cm As New OleDbCommand


    cm.CommandText = "backup database master to disk='" & Me.uitxtLocation.Text & "\" & Me.uitxtFileName.Text & ".BAK '"
    cm.Connection = conn
    conn.Open()
    cm.ExecuteNonQuery()
    conn.Close()
    MsgBox("Backup done successfully")


Catch ex As Exception
    MsgBox("An error occured while taking backup: " & ex.Message)
End Try       </pre>
<code>
<h2>History</h2>

<p>25-Sep-2008 First upload</p>

<p>25-Sep-2008 Image added</p>

License

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