I tried the following on SQL-Server:
create table #TmpLOGSPACE(
DatabaseName varchar(100)
, LOGSIZE_MB decimal(18, 9)
, LOGSPACE_USED decimal(18, 9)
, LOGSTATUS decimal(18, 9))
insert #TmpLOGSPACE(DatabaseName, LOGSIZE_MB, LOGSPACE_USED, LOGSTATUS)
DBCC SQLPERF(LOGSPACE);
...but this rises an syntax-error...
Any sugestions?
Put the statement to be run inside EXEC('')
insert #TmpLOGSPACE(DatabaseName, LOGSIZE_MB, LOGSPACE_USED, LOGSTATUS)
EXEC('DBCC SQLPERF(LOGSPACE);')
This does not directly answer the question, but it does answer the intent of the question: presumably, you want a simple way to find the current size of the log file:
SELECT size*8192.0/1024.0/1024.0 as SizeMegabytes
FROM sys.database_files
WHERE type_desc = 'LOG'
-- If the log file size is 100 megabytes, returns "100".
The reason why we multiply by 8192 is that the page size in SQL server is 8192 bytes.
The reason why we divide by 1024, then again by 1024, is to convert the size from bytes to megabytes.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With