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
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
