This is not a smart way to get rid of "The log file for database 'myDb' is full" errors; however, it does work if you do not care about backups and especially if making backups is troublesome (e.g. the database backend for a non-critical website)

DUMP TRANSACTION myDb WITH NO_LOG

Run the command above to dump the existing data in the sql server transaction log.

Related Scribbles:

SQL Server

---

ID: 737
Author:
leonard
Date Updated:
2006-01-19 15:05:12
Date Created:
2006-01-19 15:05:12

Edit

---

Comments?

 >> Leonard Chan's Homepage  >> Scribble Web  >> Empty MSSQL Transaction Log

leonard.lotus-land.ca is hosted by Perceptus Solutions Inc.