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

Differentiate between ltm and repagent?

0 Answers  

How do I correct time slice -201?

0 Answers  

What are table partitions? How is it different with ase 15.0 version?

0 Answers  

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

0 Answers  

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

0 Answers  

What is the difference between natural join and equi join?

0 Answers  

How do I configure identities in sybase?

0 Answers  

List different types of locks in sybase?

0 Answers  

Explain tds (tabular data streams).

0 Answers  

How does sybase replication work?

0 Answers  

How to find the time taken for rollback of the processed?

0 Answers  

Explain the role of replication server in sybase.

0 Answers  

For more Sybase Interview Questions Click Here
Categories