查看数据库文件地址的sql语句

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

posted @ 2021-10-04 17:44  ꧁执笔小白꧂  阅读(300)  评论(0编辑  收藏  举报