DbMaintenanceBackupTask Class

Reference

Definition

Namespace:: Microsoft.SqlServer.Management.DatabaseMaintenance

Assembly:: Microsoft.SqlServer.MaintenancePlanTasks.dll

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 ITaskDescriptionInterface

Public Class DbMaintenanceBackupTask
Inherits DatabaseMaintenanceBaseTask
Implements IContextSelection, IDbMaintenanceBackupTaskInterface, IDTSComponentPersist, ITaskDescriptionInterface

Inheritance: Object

DtsObject

Task

ExecuteSQLTask

DatabaseMaintenanceBaseTask
DbMaintenanceBackupTask

Attributes: DtsTaskAttribute GuidAttribute

Implements: IDTSComponentPersist IContextSelection IDbMaintenanceBackupTaskInterface ITaskDescriptionInterface

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)

Methods

CanDowngradeTo(Int32)	(Inherited from DatabaseMaintenanceBaseTask)
CanUpdate(String)	* Member deprecated; see Remarks. * A Boolean that indicates whether the new package XML can update the old package XML. (Inherited from Task)
CopyTo(DatabaseMaintenanceBaseTask)
DowngradeTo(Int32, XmlElement)	(Inherited from DatabaseMaintenanceBaseTask)
Equals(Object)	Determines whether two object instances are equal. (Inherited from DtsObject)
Execute(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging, Object)
GetConnectionID(Connections, String)	Gets a String containing the ID of the connection. (Inherited from Task)
GetConnectionName(Connections, String)	Gets a String containing the name of the connection. (Inherited from Task)
GetHashCode()	Returns the hash code for this instance. (Inherited from DtsObject)
InitializeTask(Connections, VariableDispenser, IDTSInfoEvents, IDTSLogging, EventInfos, LogEntryInfos, ObjectReferenceTracker)	(Inherited from DatabaseMaintenanceBaseTask)
LoadFromXML(XmlElement, IDTSInfoEvents)
OnAddedToTaskHost(TaskHost)	(Inherited from DatabaseMaintenanceBaseTask)
SaveToXML(XmlDocument, IDTSInfoEvents)
Update(String)	* Member deprecated; see Remarks. * This method updates the old package XML with the new package XML if CanUpdate(String) is set to true. (Inherited from Task)
Validate(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging)
WriteToDTSLog(IDTSLogging, String)	(Inherited from DatabaseMaintenanceBaseTask)

Applies to