How do you troubleshoot if your tempdb gets filled
Answer Posted / karthik
tempdb space issues
===================
we will try to clear the tran log by using no_log(or)trunket_only(or)normal backup
>dump tran <databasename> to "/path/<file.txt>"
>go
ofter using this command try to exe some sql quray
if it is not working
>dump tran <databasename> with trunket_only
>go
or
>dump tran <databasename> with no_log
>go
the difference between trunket_only and no_log is check point
trunket_only will wait for checkpoing and no_log is execute with out check point
even tho quary is not executed
>select lct_admin(abort,0,2)
>go
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
There is no space in file system and you need to take a back up. What will you do?
How do I open sybase control center?
Why am I running out of locks on the replicate side in sybase ?
How to pad with leading zeros an int or smallint in sybase?
What is a good example of a transaction in sybase?
You need to purge data from audit database. What will you do?
What is the timestamp datatype in sybase?
How do I move tempdb off of the master device?
What is this tds protocol in sybase?
How to fix a munged log in sybase?
When are stored procedures compiled in sybase?
How do I pipe the output of isql to a file in sybase?
How to connect sybase database from python?
What are the main differences between 11.x and 12.x versions of sybase?
Explain the role of replication server in sybase.