Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What is the difference between replication server and sql remote in sybase?

877


How do I set a password to be null?

844


How do I start sybase control center in windows?

700


What mandatory options are required for bcp command utility?

887


Is sybase a database? Explain.

907


Is sybase free?

787


When you change a database option when will it come into effect?

816


Can I partition any table in sybase ?

875


How to take backup in sybase database in sap?

839


Differences between clustered and non-clustered in sybase?

814


Is sybase sql?

820


How can set the multipal database ?

2846


Explain intimate shared memory(ism)

840


Explain asa, asa ultralite.

808


What is a natural key in sybase?

946