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.
Answer Posted / 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 View All Answers
What do you mean by sql server 2005 express management tools?
How to create an multi-statement table-valued function?
Which is the latest version of sql server and when it is released?
How to perform backup for certificates in sql server? : sql server security
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
What is the difference between getdate and sysdatetime?
What is the use of tempdb? What values does it hold?
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
What is the sql profiler?
Tell me what do you understand by a view? What does the with check option clause for a view do?
Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
What is self contained multi valued query?
Why Master database is required?
explain different types of constraints? : Sql server database administration
What is the name of the system variable that returns the number of rows affected by a SQL statement?