sql server 2008 怎么找到mdf

2025-05-01 03:16:02
推荐回答(1个)
回答1:

sql 查询 :

use master

go

select [sysdatabases].[name],[sysdatabases].[filename] as datafile,[sysaltfiles].filename as logfile from sysdatabases

 inner join sysaltfiles ON sysdatabases.dbid = sysaltfiles.dbid

where sysaltfiles.fileid = '2' and sysaltfiles.name='数据库名称'

------------------------------------------------------------------------

另一种:

在数据库上,鼠标右键-->属性-->文件--数据库文件-->路径