Generate Backup Script

-- Generate backup scripts for all databases.

select 'backup database ' + name + ' to disk=' + '''' + 'd:\SQLBackup\' + name + '.bak' + ''''
from sys.databases where name not in ('Tempdb')