BackupRestoreBase 클래스

The BackupRestoreBase class is a base class that represents functionality that is common to both backup and restore operations.

상속 계층

System. . :: . .Object
  Microsoft.SqlServer.Management.Smo..::..BackupRestoreBase
    Microsoft.SqlServer.Management.Smo. . :: . .Backup
    Microsoft.SqlServer.Management.Smo. . :: . .Restore

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

구문

‘선언
Public Class BackupRestoreBase
‘사용 방법
Dim instance As BackupRestoreBase

public class BackupRestoreBase

public ref class BackupRestoreBase

type BackupRestoreBase =  class end

public class BackupRestoreBase

BackupRestoreBase 유형에서 다음 멤버를 표시합니다.

생성자

	이름	설명
	BackupRestoreBase	Initializes a new instance of the BackupRestoreBase class.

맨 위로 이동

속성

	이름	설명
	AsyncStatus	Gets the asynchronous status of a backup or restore process.
	BlockSize	Gets or sets the physical block size of the backup or restore, in bytes.
	BufferCount	Gets or sets the total number of I/O buffers to be used for the backup or restore operation.
	Checksum	Gets or sets a Boolean property value that determines whether a checksum value is calculated during backup or restore operations.
	ContinueAfterError	Gets or sets a Boolean property value that determines whether the backup or restore continues after a checksum error occurs.
	Database	Gets or sets the database on which the backup or restore operation runs.
	DatabaseFileGroups	Gets the SQL Server file groups targeted by the backup or restore operation.
	DatabaseFiles	Gets the operating system files targeted by the backup or restore operation.
	Devices	Gets the backup devices specified for the backup or restore operation.
	MaxTransferSize	Gets or sets the maximum number of bytes to be transferred between the backup media and the instance of SQL Server.
	MediaName	Gets or sets the name used to identify a particular media set.
	NoRecovery	Gets or sets a Boolean property value that determines whether the tail of the log is backed up and whether the database is restored into the Restoring state.
	NoRewind	Gets or sets a Boolean property value that determines whether Microsoft SQL Server will keep the tape open after the backup or restore operation.
	PercentCompleteNotification	Gets or sets the percentage interval for PercentCompleteEventHandler event handler calls.
	Restart	Gets or sets a Boolean property value that determines whether the backup or restore operation will restart if it is interrupted.
	UnloadTapeAfter	Gets or sets a Boolean property value that determines whether tape media are rewound and unloaded after the backup or restore operation completes.

맨 위로 이동

메서드

	이름	설명
	Abort	Terminates a running backup or restore operation.
	Equals	(Object에서 상속됨)
	ExecuteSql	Executes a batch of Transact-SQL statements that does not expect a returned results set on the specified instance of SQL Server.
	ExecuteSqlAsync	Executes a batch of Transact-SQL statements asynchronously that does not expect a returned results set on the specified instance of SQL Server.
	ExecuteSqlWithResults	Executes a batch of Transact-SQL statements that expects one or more returned results sets on the specified instance of SQL Server.
	Finalize	(Object에서 상속됨)
	GetDevicesScript	Gets the script that is used to create devices.
	GetHashCode	(Object에서 상속됨)
	GetType	(Object에서 상속됨)
	IsStringValid	Verifies whether the specified string is valid.
	MemberwiseClone	(Object에서 상속됨)
	SetMediaPassword(SecureString)	Sets the password for a media set.
	SetMediaPassword(String)	Sets the password for a media set.
	SetPassword(SecureString)	Sets the password for a backup set.
	SetPassword(String)	Sets the password for a backup set.
	ToString	(Object에서 상속됨)
	Wait	Waits for the current backup or restore operation to complete before moving on to the next process.

맨 위로 이동

이벤트

	이름	설명
	Complete	Occurs when the backup or restore operation completes.
	Information	Occurs when any informational message is issued by Microsoft SQL Server that cannot be handled by the Complete NextMedia or PercentComplete events.
	NextMedia	Occurs when the backup or restore operation exhausts the medium in a target device.
	PercentComplete	Occurs when a backup or restore operation reaches a completion unit.

맨 위로 이동

필드

	이름	설명
	currentAsyncOperation	Specifies the current asynchronous operation, such as backup, restore, or none.
	m_BackupAction	Specifies the backup action type, such as database or log.
	m_LogTruncation	Specifies whether to truncate the log.
	m_RestoreAction	Specifies the restore action type, such as database or log.

맨 위로 이동

주의

The BackupRestoreBase class is used in the construction of the Restore class and the Backup class, and contains functionality that is common.

예

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

스레드 보안

이 유형의 모든 공용 static(Visual Basic에서는 Shared) 멤버는 스레드로부터 안전합니다. 인스턴스 멤버는 스레드로부터의 안전성이 보장되지 않습니다.

참고 항목

참조

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

관련 자료

BACKUP(Transact-SQL)

RESTORE(Transact-SQL)