If the transaction log of tempdb is full then you call login through sa a

How do you troubleshoot if your tempdb gets filled

Question Posted / aditya

13 Answers
44896 Views
HCL, I also Faced
E-Mail Answers

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

Explain data cache?

935

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

962

How to clear tempdb when the tempdb gets filled in sybase?

840

What are the catches?

886

Explain procedure cache?

961

State some of the criticism about sybase iq?

915

Explain open server?

931

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

939

How do I open a sybase database?

979

Is sybase a database? Explain.

958

What is replication server in sybase?

832

What is trace flags — 5101 and 5102 in sybase?

934

How to connect to sybase database from linux?

990

How to check database size in sybase iq?

986

What is trace flag definitions in sybase?

926