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
What is trace flags — 5101 and 5102 in sybase?
You need to purge data from audit database. What will you do?
What are the main differences between 11.x and 12.x versions of sybase?
How to save space when inserting rows monotonically?
Explain coalesce. What is the equivalent of oracle/db2 coalesce function in sybase?
Explain procedure cache and data cache in sybase.
How do I tell which tables have identities in sybase?
Why not max out all my columns sybase?
What measures are there to increase the db space?
What is server replication?
Explain about the features of sybase iq?
How do I open sybase control center?
How would you replicate col = col + 1 in sybase?
You need to remove duplicate rows from a sybase table. How would you do that?
Explain about the sybase group?