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

  1. Categories >> Software >> Databases >> Sybase
  2. Suggest New Category

How do you troubleshoot if your tempdb gets filled

Question Posted / guest

Answers were Sorted based on User's Feedback



How do you troubleshoot if your tempdb gets filled..

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

How do you troubleshoot if your tempdb gets filled..

Answer / prabhu

Do any of the following
1. restart the sybase database server
2. alter the size of the tempdb

Is This Answer Correct ?    13 Yes 24 No

How do you troubleshoot if your tempdb gets filled..

Answer / sri

use tempdb
go
sp_helpsegment "default"
go

Is This Answer Correct ?    11 Yes 25 No

Post New Answer

More Sybase Interview Questions

How do check the current running processes?

0 Answers  

What data types does sybase support?

0 Answers  

When are stored procedures compiled in sybase?

0 Answers  

What is asa ultralite in sybase?

0 Answers  

How do I set ts role in order to run certain dbccs?

0 Answers  

Explain update statistics.

0 Answers  

What you need to do is issue an ase kill command on the connection then un-suspend the db?

0 Answers  

What will cause the size of a stored procedure to grow in sybase?

0 Answers  

What is cis and how can I use it?

0 Answers  

Explain open server?

0 Answers  

How do I correct time slice -201?

0 Answers  

How to connect sybase server with unix.

3 Answers   HCL,

For more Sybase Interview Questions Click Here
Categories