生成备份所有库的语句

select 'BACKUP DATABASE '+name+' TO DISK = ''e:\ufdata\'+name+''' WITH NOINIT , NOUNLOAD , NAME = '''+name+''', NOSKIP , STATS = 10, NOFORMAT'  from master..sysdatabases
原文地址:https://www.cnblogs.com/hhq80/p/1439478.html