如何通过vb.net备份sql server 2005数据。 [英] how to make backup of sql server 2005 data through vb.net.

问题描述

如何通过vb.net备份sql server 2005数据，以便客户端用户可以轻松创建自己的数据备份。 PLZ帮我..非常紧急...

how to make backup of sql server 2005 data through vb.net so that client side user can easily create own data backup. plz help me..its very urgent...

推荐答案

你可以使用SMO



添加这些参考：

You can use SMO

Add these references:

''//***** Add these references**********
''//Microsoft.SqlServer.Smo
''//Microsoft.SqlServer.SmoExtended
''//Microsoft.SqlServer.Management.Sdk.Sfc
''//Microsoft.SqlServer.ConnectionInfo

添加这些进口商品：

Add these Imports:

Imports System.Data.SqlClient
Imports Microsoft.SqlServer.Management.Smo
Imports Microsoft.SqlServer.Management.Common

然后代码类似这样的事情：

Then code something like this:

Private Sub Backup
Dim srv As Server
Dim conn As ServerConnection
Dim sqlSErverInstance As String = "YourServerInstanceName"
Dim fileName As String = "MyBackup.bak"
Dim databaseName As String = "MyDatabase"

conn = New ServerConnection(sqlSErverInstance, "Username", "Password")
srv = New Server(conn)
Dim bkp As New Backup()
Try
            

            bkp.Action = BackupActionType.Database
            bkp.Database = databaseName
            bkp.Devices.AddDevice(fileName, DeviceType.File)
            bkp.Incremental = False
            

            bkp.PercentCompleteNotification = 10
            AddHandler bkp.PercentComplete, AddressOf ProgressEventHandler


            bkp.SqlBackup(srv)
            MessageBox.Show("Database Backed Up To: " & fileName, "Backup")

        Catch ex As Exception
            MessageBox.Show(ex.ToString())
        Finally
            Me.ProgressBar1.Value = 0
        End Try

End Sub

 Public Sub ProgressEventHandler(sender As Object, e As PercentCompleteEventArgs)
        Me.ProgressBar1.Value = e.Percent
 End Sub

有一些链接供您使用。



1. 在VB.NET中通过代码备份SQL数据库 [ ^ ]。br />
2. 如何备份VB .NET中的数据库SQL SERVER？ [ ^ ]。按照 Martin Xie - MSFT 接受的答案。



Utility

< a href =http://www.codeproject.com/Articles/21403/SQL-Server-Database-Backup-Utility-using-VB-NET-an>使用VB.NET和SQL-DMO的SQL Server数据库备份实用程序（新版本） [ ^ ]

There are some links for you.

1. Backup SQL Database Through Code In VB.NET[^].
2. How to backup database SQL SERVER from VB NET?[^]. Follow the accepted answer by Martin Xie - MSFT.

Utility
SQL Server Database Backup Utility using VB.NET and SQL-DMO (New version)[^]

这篇关于如何通过vb.net备份sql server 2005数据。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！