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 I make isql secure in sybase?

0 Answers  

How do you troubleshoot if your tempdb gets filled

13 Answers   HCL,

Explain asa, asa ultralite.

0 Answers  

How to restore sybase database in sap?

0 Answers  

Is sybase a database? Explain.

0 Answers  

How do I create a partitioned table that spans multiple devices in sybase?

0 Answers  

How to take backup in sybase database in sap?

0 Answers  

How do you check database space?

0 Answers  

How to remove row affected and dashes?

0 Answers  

What do you mean by deferred update in sybase?

0 Answers  

What is sybase infomaker?

0 Answers  

Can you create your own sps for system wise?

0 Answers  

For more Sybase Interview Questions Click Here
Categories