다음을 통해 공유


Backup.Initialize 속성

Gets or sets a Boolean property value that determines whether the devices associated with a backup operation are initialized as part of the backup operation.

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

구문

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

value = instance.Initialize

instance.Initialize = value
public bool Initialize { get; set; }
public:
property bool Initialize {
    bool get ();
    void set (bool value);
}
member Initialize : bool with get, set
function get Initialize () : boolean 
function set Initialize (value : boolean)

속성 값

유형: System.Boolean

A Boolean value that specifies whether the backup devices will be initialized.If True, the backup specified becomes the first backup set on the media, overwriting any existing backup sets on the media. The backup media is not overwritten if either of the following conditions is met:

  • All backup sets on the media have not yet expired.

  • The optionally specified backup set name does not match the name on the backup media. Specify the backup set name with the BackupSetName property.

If False (default), the backup specified creates a new backup set appended as the last backup set on the medium.

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")
Dim bk As New Backup
bk.Action = BackupActionType.Database
bk.Database = "AdventureWorks2012"
bk.Initialize = true

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.Action = [Microsoft.SqlServer.Management.Smo.BackupActionType]::Database
$bk.Database = "AdventureWorks2012"
$bk.Initialize = $TRUE

참고 항목

참조

Backup 클래스

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

관련 자료

BACKUP(Transact-SQL)

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