|
|
||||||
|
|
||||||
Workflow Screenshot
Properties
| Property | Value |
| Name | EDWDifferentialBackup |
| Description | This package will create a differential backup of the Enterprise Data Warehouse database. These backups will be kept for 7 days. If the SSIS packages do not complete successfully, the database can be restored, however additional backups of the databases should be scheduled as per the disaster recovery plan of the institutions. |
| Checkpoint File Name | |
| Checkpoint Usage | Never |
| Check Signature On Load | True |
| Creation Date | Wednesday, August 22, 2012 3:10 PM |
| Creator Computer Name | SQL1 |
| Creator Name | AD\clove |
| Debug Mode | False |
| Delay Validation | False |
| Disable | False |
| Disable Event Handlers | False |
| Enable Configurations | True |
| Encrypt Checkpoints | False |
| Fail Package On Failure | False |
| Fail Parent On Failure | False |
| Forced Execution Value | 0 |
| Force Execution Value | None |
| Description | False |
| ID | 0e4c7d04-2868-44cb-8d86-4efee24c573b |
| Interactive Mode | False |
| Is Default Locale ID | False |
| Isolation Level | Serializable |
| Locale ID | 1033 |
| Logging Mode | Enabled |
| Max Concurrent Executables | -1 |
| Maximum Error Count | 1 |
| Offline Mode | False |
| Package Type | DTSDesigner100 |
| Protection Level | DontSaveSensitive |
| Save Checkpoints | False |
| Suppress Configuration Warnings | False |
| Suspend Required | False |
| Transaction Option | Supported |
| Update Objects | False |
| Version Build | 51 |
| Version Comments | |
| Version Guid | 5b9dbe12-f80a-451e-8c5d-17c432c84251 |
| Version Major | 1 |
| Version Minor | 0 |
Executables
| Name | Type | Description |
For Each Loop |
Foreach Loop Container |
|
Task |
Execute SQL Task |
Connection Managers
| Name | Description |
Log Providers
| Name | Description |
User Defined Variables
| Name | Value | Expression | Description |
aaa |
This contains the name that will be used for the Backups for the Enterprise DW |
||
20170309_174532 |
(DT_WSTR,4)YEAR( GETDATE() )
+ RIGHT("0" + (DT_WSTR,2)MONTH( GETDATE() ), 2)
+ RIGHT("0" + (DT_WSTR,2)DAY( GETDATE() ), 2) + "_"
+ RIGHT("0" + (DT_WSTR,2)DATEPART("hh", GETDATE() ), 2)
+ RIGHT("0" + (DT_WSTR,2)DATEPART("mi", GETDATE() ), 2)
+ RIGHT("0" + (DT_WSTR,2)DATEPART("ss", GETDATE() ), 2) |
||
EnterpriseDW |
This SSIS_configuration setting contains the name of the Enterprise Datawarehouse database. |
||
C:\DW Local Stuff\Backups\ |
This SSIS_Configuration setting contains the name of the directory where the backup files for the differential backups for the EnterpriseDW database will be stored. Differential backups will be kept here for at least 7 days. |
||
SQL1 |
This SSIS_Configuration setting contains the name of the server where the Enterprise Data Warehouse is running. |
||
8/10/2012 4:57:00 PM |
|||
BACKUP DATABASE [EnterpriseDW]
TO DISK = N'C:\DW Local Stuff\Backups\EnterpriseDW_backup_20170309_174532.bak'
WITH DIFFERENTIAL
, NOFORMAT
, NOINIT
, NAME = N'EnterpriseDW_backup_20170309_174532'
, SKIP
, REWIND
, NOUNLOAD
, COMPRESSION
, STATS = 10
RESTORE VERIFYONLY
FROM DISK = N'C:\DW Local Stuff\Backups\EnterpriseDW_backup_20170309_174532.bak'
|
"
BACKUP DATABASE [" + @[User::EDWDBName] + "]
TO DISK = N'" + @[User::EDWDiffBackupFileLocation] + @[User::EDWDBName] + "_backup_" + @[User::CurrentDateTimeStamp] + ".bak'
WITH DIFFERENTIAL
, NOFORMAT
, NOINIT
, NAME = N'" + @[User::EDWDBName] + "_backup_" + @[User::CurrentDateTimeStamp] + "'
, SKIP
, REWIND
, NOUNLOAD
, COMPRESSION
, STATS = 10
RESTORE VERIFYONLY
FROM DISK = N'" + @[User::EDWDiffBackupFileLocation] + @[User::EDWDBName] + "_backup_" + @[User::CurrentDateTimeStamp] + ".bak'
"
|
System Variables
| Name | Value | Expression | Description |
| Powered by BI Documenter |
