Backup All databases

Create procedure Backup_all_databases

as

Declare @sql varchar(8000)

set @sql=''

select @sql=@sql+

'Backup database '+name+' to disk=''E:\backup\'+name+'_'+convert(varchar(8),getdate(),112)+'.bak'''

from master..sysdatabases

where

name not in ('master','tempdb','model','msdb','pubs','Northwind')

--print @sql

EXEC(@sql)

EXEC Backup_all_databases