Click here to Skip to main content
Click here to Skip to main content
Go to top

SqlServer2000 Backup Control

, 24 Sep 2008
Rate this:
Please Sign up or sign in to vote.
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        

Write following code on button click event

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       

History

25-Sep-2008 First upload

25-Sep-2008 Image added

License

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

Share

About the Author

Rai Shahid
Software Developer Lumensoft Technologies
Pakistan Pakistan
I 'm Rai Shahid working in Lumensoft Technologies as a Software Engineer. You can visit me on
http://www.softbeats.net
http://blogs.softeats.net

Comments and Discussions

 
-- There are no messages in this forum --
| Advertise | Privacy | Mobile
Web02 | 2.8.140916.1 | Last Updated 24 Sep 2008
Article Copyright 2008 by Rai Shahid
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid