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 configure sybase odbc connection?

0 Answers  

Differentiate between clustered and non-clustered index.

0 Answers  

What is this tds protocol in sybase?

0 Answers  

How to pad with leading zeros an int or smallint in sybase?

0 Answers  

How to implement if-then-else in a select clause in sybase?

0 Answers  

What command helps you to know the process running on this port, but only su can run this command?

0 Answers  

What is difference between sybase and oracle?

0 Answers  

State some of the products of sybase?

0 Answers  

How do I force an index to be used in sybase?

0 Answers  

Does table partitioning require user-defined segments in sybase?

0 Answers  

What will you do if a replication thread goes down?

0 Answers  

How would you configure burn factor in sybase?

0 Answers  

For more Sybase Interview Questions Click Here
Categories