Check SQL Server Database and Log File Size

Check SQL Server database and log file size with the stored procedure sp_SDS written by Richard Ding.

Usage:


sp_spaceused 'objname'

sp_helpdb 'objname'

sp_SDS 'objname'

Truncate a SQL Server log file


ALTER DATABASE DBNAME SET RECOVERY SIMPLE

sp_helpdb 'DBNAME'

DBCC SHRINKFILE('DBNAME_log', 0, TRUNCATEONLY)