SQLSERVER consulta localización BBDD y Logs

SELECT name, physical_name AS CurrentLocation, state_desc

FROM sys.master_files

WHERE database_id = DB_ID(N’SSISDB’) or

      database_id = DB_ID(N’BBDD1′) or

      database_id = DB_ID(N’BBDD2′)

      order by 2 desc