🚀 MSSQL RMOS - SQL Server - get all databases with MDF and LDF File Location .bak dosya yolları nerededir

1-) MSSQL RMOS - SQL Server - get all databases with MDF and LDF File Location .bak dosya yolları nerededir

SELECT

db.name AS DBName,

type_desc AS FileType,

Physical_Name AS Location

FROM

sys.master_files mf

INNER JOIN

sys.databases db ON db.database_id = mf.database_id

2023 Haziran 24 Cumartesi
235