Skip to main content

Backup and Restore SQL using 2008/2010

Hi this is program make a 2008 to back up and restore SQL server

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.

Virus note: All files are scanned once-a-day by for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.


1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.


Submitted bykevin wijaya (not verified)on Sat, 03/17/2012 - 20:12

can this program backup\restore some like store procedure....

Submitted byangelo pineda (not verified)on Thu, 03/22/2012 - 11:36

can u help me how to backup and restore in vb6?, i got an error in my code "Operation is not allowed when the object is closed" if i remove the "Conn.Close" i got an error again "Run-time Error '70' Permission Denied" pls help me.. here is my email [email protected],just pm me, tnx

here is my code:

Private Sub Command1_Click()
Dim Source, Destination As String

Source = App.Path & "\login.mdb"
Destination = App.Path & "\Backup\" & Format(Date, "mmmm dd, yyyy") & " " & Format(Time, "h_mm_ss") & ".mdb"
FileCopy Source, Destination

MsgBox " Backup!", vbInformation, ""

End Sub

Submitted byAnonymous (not verified)on Mon, 03/18/2013 - 03:21

Please I would like to have a version of OLEDB code of this backup and restore function of this code. since I am using Access database. accdb. thank you

Add new comment

This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.