Note:
— This scripts backs up all databases without having to explicitly state them
— Also names them according to database name with the date appended to the end e.g ‘DB_SYSADS_20121210.BAK’
— Change the @path parameter to where you want the backups to be dumped to
— The databases stated after the WHERE command will not be backed up. In the example above the system databases are omitted. You can add other databases within the parentheses if you want them omitted, e.g
WHERE name NOT IN (‘master’,’model’,’msdb’,’tempdb’,’AdventureWorks’,’NorthWind’)