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