Package element: Back Up Database Task

CollapseAll image

Collapse image Properties


 Name   Value 
ApartmentThreaded True
BackupAction 0
BackupCompressionOption 0
BackupDeviceType 2
BackupEncryptionAlgorithm 0
BackupEncryptorName  
BackupEncryptorType 0
BackupFileExtension bak
BackupIsIncremental False
BackupPhysicalDestinationType 2
BypassPrepare True
CodePage 1252
Connection serverbackup
ContainerName  
CopyOnlyBackup False
CreateSubFolder False
CreationName Microsoft.SqlServer.Management.DatabaseMaintenance.DbMaintenanceBackupTask, Microsoft.SqlServer.MaintenancePlanTasks, Version=12.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
CredentialName  
DatabaseSelectionType 4
DebugMode False
DelayValidation False
Description Back Up Database Task
DestinationAutoFolderPath C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP
DestinationCreationType 0
DestinationManualList  
Disable False
DisableEventHandlers False
ExecutionDuration 0
ExecutionResult Success
ExecutionStatus None
ExistingBackupsAction 0
ExpireDate 9/12/2100 12:00:00 AM
ExtendedLogging True
FailPackageOnFailure False
FailParentOnFailure False
FileGroupsFiles  
ForcedExecutionValue 0
ForceExecutionResult None
ForceExecutionValue False
HasExpressions False
HostType Task
ID {67643D28-0F1D-4144-87BE-1CFCA6A37B02}
IgnoreDatabasesInNotOnlineState False
IgnoreReplicaType False
InDays True
IsBackupEncrypted False
IsDefaultLocaleID True
IsolationLevel Serializable
IsStoredProcedure False
LocalConnectionForLogging  
LocaleID Russian (Russia)
LoggingMode UseParentSetting
MaximumErrorCount 1
Name Back Up Database Task
ObjectTypeSelection 0
ResultSetType 1
RetainDays 14
RunId {00000000-0000-0000-0000-000000000000}
SelectedDatabases System.Collections.ArrayList
SelectedTables  
ServerVersion 9
SqlStatementSource
SqlStatementSourceType Direct Input
SuspendRequired False
TableSelectionType 0
TaskAllowesDatbaseSelection True
TaskAllowesTableSelection False
TaskConnectionName serverbackup
TaskName  
TaskNameWasModified False
TimeOut 0
TransactionOption Supported
TypeConversionMode 2
UrlPrefix  
UseExpiration False
VerifyIntegrity False
Version 0

Collapse image Elements


 Name   Description   Type 
ExecuteSQLExecutingQuery Provides information about executing an SQL query. LogEntryInfos

Collapse image See also


Package index