How do you troubleshoot if your tempdb gets filled
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / prabhu
Do any of the following
1. restart the sybase database server
2. alter the size of the tempdb
Is This Answer Correct ? | 13 Yes | 24 No |
How do I open a sybase database?
What is replication in sybase?
How would you configure identities in sybase?
Explain 'forcing an index' concept.
Explain intimate shared memory(ism)
What is my identity burn factor vulnerability right now in sybase?
How to manually drop a table in sybase?
How do I make isql secure in sybase?
What do you mean by deferred update in sybase?
explain engines?
How to pad with leading zeros an int or smallint in sybase?
How would you configure burn factor in sybase?