find information about databases

Sp_helpdb

SELECT * FROM sys.master_files

SELECT * FROM sys.database_files
SELECT name, recovery_model_desc FROM sys.databases
where recovery_model=1