VB.NET - backup and retore of sql-server database in vb.net.

How to take backup of sql-server database in vb.net.

And how to retore it using vb.net.

Hi,

here is the nice article for this..

http://www.codeproject.com/KB/dotnet/SQL_Server_backup.aspx

To restore the below code will help you...

Dim restore As SQLDMO.Restore
Dim svr As SQLDMO._SQLServer

Try
restore = New SQLDMO.RestoreClass()
svr = New SQLDMO.SQLServerClass()

svr.LoginSecure = False
svr.Connect(ServerName, ADMIN_UID, ADMIN_PWD)

restore.Action = SQLDMO.SQLDMO_RESTORE_TYPE.SQLDMORestore_Database
restore.Database = dbName
restore.Files = path & BACKUP_FILE
restore.FileNumber = 1
restore.SQLRestore(svr)

svr.DisConnect()
svr = Nothing
Catch ex As Exception
MessageBox.Show(ex.ToString)
End Try

Also see this link below, it will help you...

http://www.shabdar.org/sql-server-backup-utility.html

Here is the link where you can find the sample code, I think this is exactly what you want!

Simple Backup/Restore Utility With SQL-DMO Using VB.NET

http://www.aspfree.com/c/a/VB.NET/Simple-BackupRestore-Utility-With-SQLDMO-Using-VBNET/

You can check this for more detailed backup activity that can be done in VB.net ..

http://www.c-sharpcorner.com/UploadFile/shabdarghata/sql-server-backup-utility-sql-dmo02042008134007PM/sql-server-backup-utility-sql-dmo.aspx

and these for more info..(including code given)

http://www.shabdar.org/sql-server-backup-utility.html

like;

'Server object from SQL-DMO library
Dim oServer As New SQLServer2
'Database object from SQL-DMO library
Dim db As SQLDMO.Database2
'BCP Utility from SQL-DMO Library
Dim objBCP As New SQLDMO.BulkCopy2

Function for exporting data to a file from SQL server

objBCP.DataFilePath = "c:\temp\EmployeeData.dat"
db.Tables.Item("Employee").ExportData(objBCP)

Generating SQL script for an SQL server object

'Generate script with drop statement
Dim SQL as String = db.GetObjectByName("Employee").Script_
(SQLDMO_SCRIPT_TYPE.SQLDMOScript_Drops) + db.GetObjectByName("Employee").Script()

For more details just go thr this link which will explain you step wise details to do same

http://www.codeproject.com/KB/dotnet/SQL_Server_backup.aspx

http://www.shabdar.org/sql-server-backup-utility.html

Best Luck!!!!!!!!!!
Sujit.