Condividi tramite

  • Articolo

Proprietà BackupSetDescription

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

Spazio dei nomi  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.SmoExtended (in Microsoft.SqlServer.SmoExtended.dll)

Sintassi

'Dichiarazione
Public Property BackupSetDescription As String
    Get
    Set
'Utilizzo
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)

Valore proprietà

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

Osservazioni

The BackupSetDescription property value is limited to 255 characters.

Esempi

VB

'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server
'Reference the AdventureWorks2008R2 database.
Dim db As Database
db = srv.Databases("AdventureWorks2008R2")
'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 AdventureWorks2008R2"
bk.Database = "AdventureWorks2008R2"

PowerShell

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