BackupRestoreBase BackupRestoreBase BackupRestoreBase Class

Definition

public class BackupRestoreBase
type BackupRestoreBase = class
Public Class BackupRestoreBase
Inheritance
BackupRestoreBaseBackupRestoreBaseBackupRestoreBase
Derived

Constructors

BackupRestoreBase() BackupRestoreBase() BackupRestoreBase()

base class constructor

Fields

currentAsyncOperation currentAsyncOperation currentAsyncOperation
m_BackupAction m_BackupAction m_BackupAction
m_LogTruncation m_LogTruncation m_LogTruncation
m_RestoreAction m_RestoreAction m_RestoreAction

Properties

AsyncStatus AsyncStatus AsyncStatus

A status of most recent asynchronous operation, including possible errors.

BlockSize BlockSize BlockSize
BufferCount BufferCount BufferCount
Checksum Checksum Checksum
ContinueAfterError ContinueAfterError ContinueAfterError
CredentialName CredentialName CredentialName

Gets or sets the credential name that is used by Backup to Url

Database Database Database
DatabaseFileGroups DatabaseFileGroups DatabaseFileGroups
DatabaseFiles DatabaseFiles DatabaseFiles
Devices Devices Devices

A list of devices used as a target for backup

MaxTransferSize MaxTransferSize MaxTransferSize
MediaName MediaName MediaName
NoRecovery NoRecovery NoRecovery
NoRewind NoRewind NoRewind
PercentCompleteNotification PercentCompleteNotification PercentCompleteNotification
Restart Restart Restart
RetryFailedQueries RetryFailedQueries RetryFailedQueries
UnloadTapeAfter UnloadTapeAfter UnloadTapeAfter

Methods

Abort() Abort() Abort()

Aborts the current action, if any

CheckForHADRMaintPlan(Server, StringBuilder) CheckForHADRMaintPlan(Server, StringBuilder) CheckForHADRMaintPlan(Server, StringBuilder)

If invoked from Maintenance plan Check if HADR is enabled

ExecuteSql(Server, StringCollection) ExecuteSql(Server, StringCollection) ExecuteSql(Server, StringCollection)
ExecuteSqlAsync(Server, StringCollection) ExecuteSqlAsync(Server, StringCollection) ExecuteSqlAsync(Server, StringCollection)
ExecuteSqlWithResults(Server, String) ExecuteSqlWithResults(Server, String) ExecuteSqlWithResults(Server, String)
GetDevicesScript(StringBuilder, BackupDeviceList, ServerVersion) GetDevicesScript(StringBuilder, BackupDeviceList, ServerVersion) GetDevicesScript(StringBuilder, BackupDeviceList, ServerVersion)
IsBackupFileDeviceSupported(DatabaseEngineEdition) IsBackupFileDeviceSupported(DatabaseEngineEdition) IsBackupFileDeviceSupported(DatabaseEngineEdition)

Helper to check if BackupToFile is supported on the connected server edition. SQL Managed Instances do not support backup to file.

IsBackupUrlDeviceSupported(ServerVersion) IsBackupUrlDeviceSupported(ServerVersion) IsBackupUrlDeviceSupported(ServerVersion)

Helper to check if BackupToUrl is supported on the connected server version

IsStringValid(String) IsStringValid(String) IsStringValid(String)
SetMediaPassword(SecureString) SetMediaPassword(SecureString) SetMediaPassword(SecureString)
SetMediaPassword(String) SetMediaPassword(String) SetMediaPassword(String)
SetPassword(SecureString) SetPassword(SecureString) SetPassword(SecureString)
SetPassword(String) SetPassword(String) SetPassword(String)
Wait() Wait() Wait()

Waits for the current asynchronous action to complete.

Events

Complete Complete Complete

Complete event

Information Information Information

Information event

NextMedia NextMedia NextMedia

NextMedia event

PercentComplete PercentComplete PercentComplete

PercentComplete event

Applies to