BackupRestoreBase Members

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

The following tables list the members exposed by the BackupRestoreBase type.

Public Constructors

	名稱	Description
	BackupRestoreBase	Initializes a new instance of the BackupRestoreBase class.

頂端

Protected Fields

	名稱	Description
	currentAsyncOperation
	m_BackupAction
	m_LogTruncation
	m_RestoreAction

頂端

Public Properties

	名稱	Description
	AsyncStatus	Gets the asynchronous status of a backup or restore process.
	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 Microsoft 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. This property is not CLS-compliant.
	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.

頂端

Public Methods

(see also Protected Methods )

	名稱	Description
	Abort	Terminates a running backup or restore operation.
	Equals	Overloaded. (inherited from Object )
	GetHashCode	(inherited from Object )
	GetType	(inherited from Object )
	ReferenceEquals	(inherited from Object )
	SetMediaPassword	Overloaded. Sets the password for a media set.
	SetPassword	Overloaded. Sets the password for a backup set.
	ToString	(inherited from Object )
	Wait	Waits for the current backup or restore operation to complete before moving on to the next process.

頂端

Protected Methods

	名稱	Description
	ExecuteSql	Executes a batch of Transact-SQL statements that does not expect a returned results set on the specified instance of Microsoft SQL Server.
	ExecuteSqlAsync	Executes a batch of Transact-SQL statements asynchronously that does not expect a returned results set on the specified instance of Microsoft 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	(inherited from Object )
	GetDevicesScript
	IsStringValid	Verifies whether the specified string is valid.
	MemberwiseClone	(inherited from Object )

頂端

Public Events

	名稱	Description
	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 CompleteNextMedia 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.

頂端

請參閱

參考

BackupRestoreBase Class
Microsoft.SqlServer.Management.Smo Namespace

其他資源

BACKUP (Transact-SQL)
RESTORE (Transact-SQL)
在 SQL Server 中備份和還原資料庫