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
What is the difference between replication server and sql remote in sybase?
How do I set a password to be null?
How do I start sybase control center in windows?
What mandatory options are required for bcp command utility?
Is sybase a database? Explain.
Is sybase free?
When you change a database option when will it come into effect?
Can I partition any table in sybase ?
How to take backup in sybase database in sap?
Differences between clustered and non-clustered in sybase?
Is sybase sql?
How can set the multipal database ?
Explain intimate shared memory(ism)
Explain asa, asa ultralite.
What is a natural key in sybase?