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 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_ONLYFor 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.
Do u know if Rails is enough robust with SQL Server ?
Define robust. All I know is, that after 3 weeks of RoR development using SQL Server I have yet to hit any major problems directly related to the SQL Server adapter.