EDWDifferentialBackup
 SQL_BackupEnterpriseDW (Variable)
Home  Diagrams  Documents  Images  EDWDifferentialBackup  Executables  Connection Managers  Log Providers  Variables 
Current Path:  EDWDifferentialBackup   Variables   SQL_BackupEnterpriseDW
  Properties
Property Value
Name SQL_BackupEnterpriseDW
Value Expression: " 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' "

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'
Value Type String
Description
System Variable False
Namespace User
Qualified Name User::SQL_BackupEnterpriseDW
Evaluate As Expression True
Expression " 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' "
ID c2c73dd9-362a-4f53-8fd7-8f9a79b2c1ce
Raise Changed Event False
Powered by BI Documenter