SELECT b.name,a.physical_name
FROM master.sys.master_files as a , sys.databases as b
where a.database_id = b.database_id
and a.physical_name not like '%.ldf'
and b.name not in ('master','tempdb','msdb','model','LitespeedLocal')
order by b.name
查询所有数据库数据文件的SQL
最新推荐文章于 2021-04-15 15:29:25 发布