共用方式為

Backup.BackupSetDescription 屬性

  • 發行項

Gets or sets a textual description for a particular backup set.

命名空間：  Microsoft.SqlServer.Management.Smo
組件：  Microsoft.SqlServer.SmoExtended (在 Microsoft.SqlServer.SmoExtended.dll 中)

語法

'宣告
Public Property BackupSetDescription As String 
    Get 
    Set
'用途
Dim instance As Backup 
Dim value As String 

value = instance.BackupSetDescription

instance.BackupSetDescription = value

public string BackupSetDescription { get; set; }

public:
property String^ BackupSetDescription {
    String^ get ();
    void set (String^ value);
}

member BackupSetDescription : string with get, set

function get BackupSetDescription () : String 
function set BackupSetDescription (value : String)

屬性值

型別：System.String
A String value that contains a textual description of the backup set. By default, the value is an empty string.

備註

The BackupSetDescription property value is limited to 255 characters.

範例

VB

'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")
'Define a Backup object variable. 
Dim bk As New Backup
'Specify the description of the database to be backed up.
bk.BackupSetDescription = "Full backup of AdventureWorks2012"
bk.Database = "AdventureWorks2012"

PowerShell

$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
$db = New-Object Microsoft.SqlServer.Management.Smo.Database
$db = $srv.Databases.Item("AdventureWorks2012")
$bk = new-object Microsoft.SqlServer.Management.Smo.Backup
$bk.BackupSetDescription = "Full backup of AdventureWorks2012"
$bk.Database = "AdventureWorks2012"

請參閱

參考

Backup 類別

Microsoft.SqlServer.Management.Smo 命名空間

其他資源

BACKUP (Transact-SQL)