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 / 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


Please Help Members By Posting Answers For Below Questions

You want to delete a table in sybase. How would you do it?

800


What is my identity burn factor vulnerability right now in sybase?

828


How can you change to get the decimal separator as comma instead of the decimal point (.)?

808


What do you mean by sybase iq?

846


How would you configure burn factor in sybase?

884


Must I use multiple devices to take advantage of partitions in sybase?

857


How can I improve throughput in sybase?

847


What is sybase infomaker?

878


What is a natural key in sybase?

946


When should I execute an sp_recompile in sybase?

822


What is the difference between 'dump tran database to physical name' 'dump tran database with truncate_only' and dump tran database with no_log'and in real time when we go to truncate the log?

848


What is procedure cache and data cache in sybase?

787


How to check if sybase database is up and running?

774


What mandatory options are required for bcp command utility?

887


How to check sybase database status in linux?

939