批量生成恢复语句
SELECT 'restore database '+Name+' from disk=''D:\数据库备份-12-14x\'+Name+'.bak'' with RECOVERY,REPLACE,move SalesMis to ''E:\MisData\'+Name+'\'+Name+'.mdf'', move SalesMis_log to ''E:\MisData\'+Name+'\'+Name+'_log.ldf''  ;' FROM Master..SysDatabases  where name<>'master' and name<>'model' and name<>'msdb ' and name<>'tempdb' ORDER BY Name 

批量生成备份语句

SELECT  'backup database '+Name+' to disk=''D:\数据库备份-12-14x\'+Name+'.bak'';' FROM Master..SysDatabases  where name<>'master' and name<>'model' and name<>'msdb ' and name<>'tempdb' ORDER BY Name 

批量生成删除数据库语句

SELECT 'ALTER DATABASE '+Name+'  SET SINGLE_USER with ROLLBACK IMMEDIATE  

GO  

DROP DATABASE '+Name+';' FROM Master..SysDatabases  where name<>'master' and name<>'model' and name<>'msdb ' and name<>'tempdb' ORDER BY Name