Friday, February 22, 2013

Files to skip in online backups

If you use backup providors like backblaze, mozy, or carbonite, they will often exclude certain file types.
These are know files that are not critical. If your backup software does not make this exclusion you can copy the list below, and add it to the exclusion list.


*.113
*.$$
*.$DB
*.ABF
*.ABK
*.AFM
*.ANI
*.ANN
*.BAC
*.BAK
*.BCK
*.BCM
*.BDB
*.BDF
*.BKF
*.BKP
*.BMK
*.BSC
*.CAB
*.CF1
*.CHM
*.CHQ
*.CHW
*.CNT
*.COM
*.CPL
*.FFL
*.CUR
*.DEV
*.DFONT
*.DLL
*.DMP
*.DRV
*.DRV
*.DVD
*.EOT
*.EVT
*.EXE
*.FFA
*.FFO
*.FFX
*.FNT
*.FON
*.FTG
*.FTS
*.FXP
*.GID
*.GRP
*.HLP
*.HXI
*.HXQ
*.HXR
*.HXS
*.ICO
*.IDB
*.IDX
*.ILK
*.IMG
*.INF
*.INI
*.INS
*.IPF
*.ISO
*.ISP
*.ITS
*.JAR
*.JSE
*.KBD
*.KEXT
*.KEY
*.LEX
*.LIB
*.LNK
*.LOG
*.LWFN
*.MSC
*.MSI
*.MSM
*.MSP
*.MST
*.NCB
*.NT
*.OBJ
*.OBS
*.OCX
*.OST
*.OTF
*.PCH
*.PF
*.PFA
*.PFB
*.PFM
*.PLIST
*.PNF
*.POL
*.PREF
*.PRF
*.PRG
*.PRN
*.PWL
*.RDB
*.REG
*.REG
*.RLL
*.ROX
*.SBR
*.SCF
*.SCR
*.SDB
*.SHB
*.SUIT
*.SWF
*.SWP
*.SYS
*.THEME
*.TMP
*.TMS
*.TTC
*.TTF
*.V2I
*.VBE
*.VGA
*.VGD
*.VHD
*.VMC
*.VMDK
*.VMSD
*.VMSN
*.VMX
*.VXD
*.WIN
*.WPK
*.mp3
*.wmv
*.mp4

Friday, February 15, 2013

SSIS Expression to get Current Date and Time

Needed this too many times so posting for future referance


(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("hour",(GETDATE())),2) + RIGHT("0" + (DT_WSTR,2)DATEPART("minute",(GETDATE())),2) + RIGHT("0" + (DT_WSTR,2)DATEPART("second",(GETDATE())),2)

will get you

20130215131907