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' "