Imports Microsoft.SqlServer.Management.Smo
Public Class Form1
  Private Sub Form1_Load(ByVal sender As System.Object, _
              ByVal e As System.EventArgs) Handles MyBase.Load
    Dim s2k5 As New Server()
    For Each db As Database In s2k5.Databases ? Loop through the databases
      Databases.Items.Add(db.Name) ? Add database name to the ListBox
    Next
  End Sub
  Private Sub DoBackup_Click(ByVal sender As System.Object, _
                ByVal e As System.EventArgs) Handles DoBackup.Click
    ? Get database name from the ListBox
    Dim db As String = Databases.SelectedItem.ToString()
    Dim dbBck As String = «C:» & db & «.bak»
    Dim bck As New Backup() ? Instantiate a Backup object
    bck.Action = BackupActionType.Database ? Set Action property
    bck.BackupSetName = db & «_BackupSet» ? Set BackupSetName property
    bck.Database = db ? Set Database name property
    bck.DeviceType = DeviceType.File ? Set DeviceType property
    ? Add method adds file to Devices collection
    bck.Devices.Add(dbBck)
    Dim s2k5 As New Server() ? Instantiate a Server object
    bck.SqlBackup(s2k5) ? Invoke Backup object?s SqlBackup method
    Dim rst As New Restore() ? Instantiate a Restore object
    rst.DeviceType = DeviceType.File ? Set DeviceType property
    ? Add method adds file to Devices collection
    rst.Devices.Add(dbBck)
    If rst.SqlVerify(s2k5) Then ? Similar to VERIFY RESTOREONLY
      MessageBox.Show(db & « backup verified»)
    Else
      MessageBox.Show(db & « backup error»)
    End If
  End Sub
End Class

Поделитесь материалом с коллегами и друзьями