Backup.SqlBackup(Server) Backup.SqlBackup(Server) Backup.SqlBackup(Server) Method


Performs the database backup operation as specified by the properties of the Backup object used.

 void SqlBackup(Microsoft::SqlServer::Management::Smo::Server ^ srv);
public void SqlBackup (Microsoft.SqlServer.Management.Smo.Server srv);
Public Sub SqlBackup (srv As Server)
Server Server Server

The Server object that represents the MicrosoftSQL Server instance that is the source of the backup operation.



'Connect to the local, default instance of SQL Server.  
Dim srv As Server  
srv = New Server  
'Reference the AdventureWorks2012 database.  
Dim db As Database  
db = srv.Databases("AdventureWorks2012")  
'Store the current recovery model in a variable.  
Dim recoverymod As Integer  
recoverymod = db.DatabaseOptions.RecoveryModel  
'Define a Backup object variable.   
Dim bk As New Backup  
'Specify the type of backup, the description, the name, and the database to be backed up.  
bk.Action = BackupActionType.Database  
bk.BackupSetDescription = "Full backup of AdventureWorks2012"  
bk.BackupSetName = "AdventureWorks2012 Backup"  
bk.Database = "AdventureWorks2012"  
'Declare a BackupDeviceItem by supplying the backup device file name in the constructor, and the type of device is a file.  
Dim bdi As BackupDeviceItem  
bdi = New BackupDeviceItem("Test_Full_Backup1", DeviceType.File)  
'Add the device to the Backup object.  
'Set the Incremental property to False to specify that this is a full database backup.  
bk.Incremental = False  
'Set the expiration date.  
Dim backupdate As New Date  
backupdate = New Date(2006, 10, 5)  
bk.ExpirationDate = backupdate  
'Specify that the log must be truncated after the backup is complete.  
bk.LogTruncation = BackupTruncateLogType.Truncate  
'Run SqlBackup to perform the full database backup on the instance of SQL Server.  


$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")  
$db = New-Object Microsoft.SqlServer.Management.Smo.Database  
$db = $srv.Databases.Item("AdventureWorks2012")  
$recoverymod = $db.DatabaseOptions.RecoveryModel  
$bk = new-object Microsoft.SqlServer.Management.Smo.Backup  
$bk.Action = [Microsoft.SqlServer.Management.Smo.BackupActionType]::Database  
$bk.BackupSetDescription = "Full backup of AdventureWorks2012"  
$bk.BackupSetName = "AdventureWorks2012 Backup"  
$bk.Database = "AdventureWorks2012"  
$bdi = new-object Microsoft.SqlServer.Management.Smo.BackupDeviceItem("Test_Full_Backup1", [Microsoft.SqlServer.Management.Smo.DeviceType]::File)  
$bk.Incremental = $FALSE  
$backupDate = new-object System.DateTime(2006, 10, 5)  
$bk.ExpirationDate = $backupDate  
$bk.LogTruncation = [Microsoft.SqlServer.Management.Smo.BackupTruncateLogType]::Truncate  


To perform a database backup operation using SQL Server Management Objects (SMO), the application specifies the operation process by setting Backup object properties, and then it calls the SqlBackup method.

Applies to