Thursday, November 1, 2012

Script to find Log file Original Size and Growth value.

Here is a small script you to run.
You can get various results from the same script by small modifications.

SELECT DB_NAME(database_id) AS DatabaseName,
Name AS Logical_Name,
Physical_Name as 'Locate/PhysicalName', (size*8)/1024 SizeMB,
(growth*8)/1024 Growth
FROM sys.master_files
WHERE database_id >4 -- to avoid system databases
and DB_NAME(database_id) <> ('ReportServerTempDB')
and Name like ('%_Log') -- Just log files



No comments:

Post a Comment