BackupRestoreBase Members
Include Protected Members
Include Inherited Members
The BackupRestoreBase class is a base class that represents functionality that is common to both backup and restore operations.
The BackupRestoreBase type exposes the following members.
Constructors
Name | Description | |
---|---|---|
BackupRestoreBase() | Initializes a new instance of the BackupRestoreBase class. |
Top
Methods
Name | Description | |
---|---|---|
Abort() | Terminates a running backup or restore operation. | |
Equals(Object) | (Inherited from Object.) | |
ExecuteSql(Server, StringCollection) | Executes a batch of Transact-SQL statements that does not expect a returned results set on the specified instance of SQL Server. | |
ExecuteSqlAsync(Server, StringCollection) | Executes a batch of Transact-SQL statements asynchronously that does not expect a returned results set on the specified instance of SQL Server. | |
ExecuteSqlWithResults(Server, String) | 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(StringBuilder, BackupDeviceList, ServerVersion) | ||
GetHashCode() | (Inherited from Object.) | |
GetType() | (Inherited from Object.) | |
IsStringValid(String) | Verifies whether the specified string is valid. | |
MemberwiseClone() | (Inherited from 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() | (Inherited from Object.) | |
Wait() | Waits for the current backup or restore operation to complete before moving on to the next process. |
Top
Properties
Name | Description | |
---|---|---|
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. |
Top
Events
Name | 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 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. |
Top