How to clear your SQL Server transaction logs


If you are receiving errors that your transaction logs are full or your Primary Filegroup is full (which may not actually mean your database is full), then log into your database with SQL Server Query Analyzer or Alentus DB Manager, and run this script to clear your transaction logs:

DUMP TRANSACTION [database_name] WITH NO_LOG

Add Feedback