The MS SQL Server transaction log
The transaction log grows, grows, grows and quite often fills up.
I know two ways of shrinking it:
- With backup:
backup log netmeter(db_name) to disk=’specify the filename’
- Without backup:
backup log netmeter with truncate_only