adspace


Tempdb is full. How would you clear it?

Answer Posted / Nitesh Kumar Singh

In Sybase, to clear TempDB, you can perform a 'SHUTDOWN' operation followed by a 'STARTUP'. However, be aware that this action will drop all temporary objects in the database. To avoid losing ongoing work, consider using 'ALTER DATABASE TEMPDATA CLEAN ALL' command which cleans the temporary data but does not affect the database itself.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

No New Questions to Answer in this Category !!    You can

Post New Questions

Answer Questions in Different Category