SQL Server 2000 seems confused
So I am getting this error in my Windows Application Event Log:
The log file for database ‘tempdb’ is full. Back up the transaction log for the database to free up some log space.
Fair enough, it happens. But when I go to backup the tempdb database using Enterprise Manager, I get this message:
Backup and restore operations are not allowed on database tempdb.
Someone tell that to whoever wrote the event log message. :)
The solution?
The proper solution is likely to manually grow the tempdb files to a more appropriate level than the current. Ah well, I’m no DBA, and this seem to have solved the issue for now:
BACKUP LOG tempdb WITH TRUNCATE_ONLY
For some reason that command completes without errors, even though "Backup and restore operations are not allowed on database tempdb. There definitely seems to be some confusion as to what’s allowed and what isn’t.