Backup.BackupSetName 속성

Gets or sets the name used to identify a particular backup set.

네임스페이스:  Microsoft.SqlServer.Management.Smo
어셈블리:  Microsoft.SqlServer.SmoExtended(Microsoft.SqlServer.SmoExtended.dll)

구문

‘선언
Public Property BackupSetName As String 
    Get 
    Set
‘사용 방법
Dim instance As Backup 
Dim value As String 

value = instance.BackupSetName

instance.BackupSetName = value
public string BackupSetName { get; set; }
public:
property String^ BackupSetName {
    String^ get ();
    void set (String^ value);
}
member BackupSetName : string with get, set
function get BackupSetName () : String 
function set BackupSetName (value : String)

속성 값

유형: System.String
A String value that specifies the backup set name. By default, the value is set to an empty string.

주의

The BackupSetName property value is limited to 128 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 the name of the database to be backed up.
bk.BackupSetName = "AdventureWorks2012 Backup"
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.BackupSetName = "AdventureWorks2012 Backup"
$bk.Database = "AdventureWorks2012"

참고 항목

참조

Backup 클래스

Microsoft.SqlServer.Management.Smo 네임스페이스

관련 자료

BACKUP(Transact-SQL)

데이터베이스 및 트랜잭션 로그 백업 및 복원