select database_id,name,physical_name AS CurrentLocation,state_desc,size from sys.master_files where database_id=db_id(N'数据库名');
https://blog.csdn.net/weixin_34332352/article/details/116858340
查看数据库文件地址的sql语句
365个夜晚，我希望做到两天更一篇博客。加油，小白！
select database_id,name,physical_name AS CurrentLocation,state_desc,size from sys.master_files where database_id=db_id(N'数据库名');
https://blog.csdn.net/weixin_34332352/article/details/116858340