1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

my problem is tempdb

tempdb(dbname) 77752.95 MB(db size) 25345.03 MB
(unallocated size)

suppose i increased temp db size 10 gb . after increase the
temp db showing

87 gb (dbsize) 25346.03MB(unallocated
size)--unallocated size is showing same .please clarify.

Question Posted / hari


my problem is tempdb tempdb(dbname) 77752.95 MB(db size) 25345.03 MB (unallocated size) su..

Answer / guest

when you increase the size, make sure that there is enough
space on the drive, if there is no enough space on
drive,then it does not reflect.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

0 Answers  

Can sql servers linked to other servers?

0 Answers  

To which devices can a backup be created and where should these devices be located? : sql server management studio

0 Answers  

What are “lost updates”?

0 Answers  

How to update multiple rows with one update statement in ms sql server?

0 Answers  




How do you persist objects, permissions in tempdb

1 Answers  

Explain about extended stored procedure?

0 Answers  

Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration

0 Answers  

How to call stored procedure using http soap?

0 Answers  

What is the order in which the SQL query is executed? list them in order.

5 Answers   CarrizalSoft Technologies, CTS, Oracle,

Mention the different authentication modes in sql server.

0 Answers  

What is DCL?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories