Monday, 22 February 2010

Truncate tempdb

The following command can be run if tempdb reports that it is out of space.

BACKUP LOG TEMPDB WITH TRUNCATE_ONLY

This command is not available in SQL2008 and above

Recycle the Error Log

dbcc errorlog