How do you troubleshoot if your tempdb gets filled
Answer Posted / aditya
If the transaction log of tempdb is full then you call
login through sa and type following command.
> dump tran tempdb with trancate_only
> go
If the database is full then you can increase the size of
the database on a free device.
> alter database tempdb on device_name = size
> go
| Is This Answer Correct ? | 2 Yes | 8 No |
Post New Answer View All Answers
Is sybase sql?
How to compute database fragmentation in sybase?
How do I remove duplicate rows from a table in sybase?
How do I open a sybase database?
How does partition assignment relate to transactions in sybase?
What do you mean by exception log in replication?
What is replication server?
How do the blocker processes exist internally in sybase?
How do I open sybase control center?
What is table partitioning in sybase?
What is an advantage to using a stored procedure as opposed to passing an sql query from an application ?
Explain index covering?
Explain the advantages of sybase iq.
Using large raw partitions with replication server on unix in sybase?
What is asa ultralite in sybase?