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

Is sybase sql?

948


How to compute database fragmentation in sybase?

947


How do I remove duplicate rows from a table in sybase?

954


How do I open a sybase database?

1053


How does partition assignment relate to transactions in sybase?

941


What do you mean by exception log in replication?

1069


What is replication server?

971


How do the blocker processes exist internally in sybase?

950


How do I open sybase control center?

1002


What is table partitioning in sybase?

946


What is an advantage to using a stored procedure as opposed to passing an sql query from an application ?

969


Explain index covering?

878


Explain the advantages of sybase iq.

947


Using large raw partitions with replication server on unix in sybase?

1010


What is asa ultralite in sybase?

984