Package element: Back Up Database Task
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 |
Elements
| Name | Description | Type |
| ExecuteSQLExecutingQuery | Provides information about executing an SQL query. | LogEntryInfos |
See also