Tips and scripts relating to database administration. Mainly SQL Server but some MySQL and every now and again something different. Posts are brief and to the point.It's as much a place to make notes for my own use as anything else.
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
No comments:
Post a Comment