Here’s a simple script for Microsoft SQL Server that list all databases, database file names and locations, and their sizes. In addition it shows recovery model and last backup LSN.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 |
USE master GO SELECT d.name AS DatabaseName, f.name AS DBFileName, f.type_desc, f.physical_name AS DBFileLocation, CAST(f.size AS decimal(38,2)) /128 AS DBFileSize_MB, CASE WHEN d.recovery_model = 1 AND r.last_log_backup_lsn IS NULL THEN 'Pseudo-Full' ELSE d.recovery_model_desc END AS EffectiveRecoveryModel, r.last_log_backup_lsn FROM sys.databases d JOIN sys.master_files f ON d.database_id = f.database_id JOIN sys.database_recovery_status r ON d.database_id = r.database_id ORDER BY d.name, f.[type], f.name; GO |