DbMaintenanceBackupTask Class
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
public ref class DbMaintenanceBackupTask : Microsoft::SqlServer::Management::DatabaseMaintenance::DatabaseMaintenanceBaseTask, Microsoft::SqlServer::Dts::Runtime::IDTSComponentPersist, Microsoft::SqlServer::Management::DatabaseMaintenance::IContextSelection, Microsoft::SqlServer::Management::DatabaseMaintenance::IDbMaintenanceBackupTaskInterface, Microsoft::SqlServer::Management::DatabaseMaintenance::ITaskDescriptionInterface[Microsoft.SqlServer.Dts.Runtime.DtsTask(IconResource="BackupTaskIcon", LocalizationType=typeof(Microsoft.SqlServer.Management.DatabaseMaintenance.MaintBackupTask), RequiredProductLevel=Microsoft.SqlServer.Dts.Runtime.DTSProductLevel.None, TaskContact="Back Up Database Task; Microsoft Corporation; Microsoft SQL Server v9; © 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1", TaskType="DBMAINT90", UITypeName="Microsoft.SqlServer.Management.DatabaseMaintenance.DbMaintTaskBackupUI, Microsoft.SqlServer.MaintenancePlanTasksUI, Version=13.0.0.0, Culture=Neutral, PublicKeyToken=89845dcd8080cc91")]
[System.Runtime.InteropServices.Guid("8e9ba4eb-9e3d-427d-932b-a8c06f7d6e27")]
public class DbMaintenanceBackupTask : Microsoft.SqlServer.Management.DatabaseMaintenance.DatabaseMaintenanceBaseTask, Microsoft.SqlServer.Dts.Runtime.IDTSComponentPersist, Microsoft.SqlServer.Management.DatabaseMaintenance.IContextSelection, Microsoft.SqlServer.Management.DatabaseMaintenance.IDbMaintenanceBackupTaskInterface, Microsoft.SqlServer.Management.DatabaseMaintenance.ITaskDescriptionInterface[<Microsoft.SqlServer.Dts.Runtime.DtsTask(IconResource="BackupTaskIcon", LocalizationType=typeof(Microsoft.SqlServer.Management.DatabaseMaintenance.MaintBackupTask), RequiredProductLevel=Microsoft.SqlServer.Dts.Runtime.DTSProductLevel.None, TaskContact="Back Up Database Task; Microsoft Corporation; Microsoft SQL Server v9; © 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1", TaskType="DBMAINT90", UITypeName="Microsoft.SqlServer.Management.DatabaseMaintenance.DbMaintTaskBackupUI, Microsoft.SqlServer.MaintenancePlanTasksUI, Version=13.0.0.0, Culture=Neutral, PublicKeyToken=89845dcd8080cc91")>]
[<System.Runtime.InteropServices.Guid("8e9ba4eb-9e3d-427d-932b-a8c06f7d6e27")>]
type DbMaintenanceBackupTask = class
inherit DatabaseMaintenanceBaseTask
interface IDbMaintenanceBackupTaskInterface
interface IContextSelection
interface IDTSComponentPersist
interface ITaskDescriptionInterfacePublic Class DbMaintenanceBackupTask
Inherits DatabaseMaintenanceBaseTask
Implements IContextSelection, IDbMaintenanceBackupTaskInterface, IDTSComponentPersist, ITaskDescriptionInterface- Inheritance
- Attributes
- Implements
Constructors
| DbMaintenanceBackupTask() |
Fields
| DefaultBlockSize | |
| DefaultMaxTransferSize |
Properties
| BackupAction | |
| BackupCompressionOption | |
| BackupDeviceType | |
| BackupEncryptionAlgorithm | |
| BackupEncryptorName | |
| BackupEncryptorType | |
| BackupFileExtension | |
| BackupIsIncremental | |
| BackupPhysicalDestinationType | |
| BlockSize | |
| BypassPrepare |
Gets or sets a Boolean that indicates whether the Execute SQL task skips preparation of the statement when sending the SQL statement to the relational database management system (RDBMS). (Inherited from ExecuteSQLTask) |
| Checksum | |
| CodePage |
Gets or sets the code page to use when translating variable values that are stored as Unicode wide chars to multi-bytes. Translation occurs either when storing values to or extracting values from databases. (Inherited from ExecuteSQLTask) |
| Connection |
Gets or sets the name of the connection manager that connects to the relational database management system (RDBMS) where the Execute SQL task is run. (Inherited from ExecuteSQLTask) |
| ContainerName | |
| ContinueOnError | |
| CopyOnlyBackup | |
| CreateSubFolder | |
| CredentialName | |
| DatabaseSelectionType | (Inherited from DatabaseMaintenanceBaseTask) |
| Description | |
| DestinationAutoFolderPath | |
| DestinationCreationType | |
| DestinationManualList | |
| ExecutionValue |
Returns the number of rows affected by the SQL statement or statements. (Inherited from ExecuteSQLTask) |
| ExistingBackupsAction | |
| ExpireDate | |
| ExtendedLogging | (Inherited from DatabaseMaintenanceBaseTask) |
| FileGroupsFiles | |
| IgnoreDatabasesInNotOnlineState | (Inherited from DatabaseMaintenanceBaseTask) |
| IgnoreReplicaType | |
| InDays | |
| IsBackupEncrypted | |
| IsBlockSizeUsed | |
| IsMaxTransferSizeUsed | |
| IsStoredProcedure |
Gets or sets a Boolean that indicates whether the SQL statement specified by the Execute SQL task is a stored procedure. (Inherited from ExecuteSQLTask) |
| LocalConnectionForLogging | (Inherited from DatabaseMaintenanceBaseTask) |
| MaxTransferSize | |
| ObjectTypeSelection | (Inherited from DatabaseMaintenanceBaseTask) |
| ParameterBindings |
Returns an object that implements IDTSParameterBindings. (Inherited from ExecuteSQLTask) |
| ResultSetBindings |
Returns an object that implements IDTSParameterBindings. (Inherited from ExecuteSQLTask) |
| ResultSetType |
Gets or sets a value that indicates the type of result set returned by the SQL statement that the Execute SQL tasks runs. (Inherited from ExecuteSQLTask) |
| RetainDays | |
| RunId | (Inherited from DatabaseMaintenanceBaseTask) |
| SelectedDatabases | (Inherited from DatabaseMaintenanceBaseTask) |
| SelectedTables | (Inherited from DatabaseMaintenanceBaseTask) |
| ServerVersion | (Inherited from DatabaseMaintenanceBaseTask) |
| SqlBatchCommands | (Inherited from DatabaseMaintenanceBaseTask) |
| SqlStatementSource |
Gets or sets the name of the source that contains the SQL statement that the Execute SQL task runs. (Inherited from ExecuteSQLTask) |
| SqlStatementSourceType |
Gets or sets a value that indicates the type of source that contains the SQL statement that the Execute SQL task runs. (Inherited from ExecuteSQLTask) |
| TableSelectionType | (Inherited from DatabaseMaintenanceBaseTask) |
| TargetServerVersion | (Inherited from Task) |
| TaskAllowesDatbaseSelection | |
| TaskAllowesTableSelection | |
| TaskConnectionName | (Inherited from DatabaseMaintenanceBaseTask) |
| TaskName | (Inherited from DatabaseMaintenanceBaseTask) |
| TaskNameWasModified | (Inherited from DatabaseMaintenanceBaseTask) |
| TimeOut |
Gets or sets an integer that indicates the maximum number of seconds the task can run before timing out. (Inherited from ExecuteSQLTask) |
| TypeConversionMode |
Gets or sets the conversion mode used by the Execute SQL Task. (Inherited from ExecuteSQLTask) |
| UrlPrefix | |
| UseExpiration | |
| VerifyIntegrity | |
| Version |
*** Member deprecated; see Remarks. *** Returns the version of the task. This property is read-only. (Inherited from Task) |