Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
celine
Starting Member
2 Posts |
 Posted - 2010-04-30 : 11:42:02
|
| Dear All, Urgently can anybody help me how to reduce the tempdb size automatically in sql server 2005. Thanks for your kind support |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2010-04-30 : 12:55:59
|
| one options is set autoshrink database property, but that may affect performance |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-04-30 : 13:11:13
|
| My advice is do NOT shrink TEMPDB, no buts!Shrinking TEMPDB whilst there are any data changes runs the risk of corrupting data ... so, in practice, you have to start SQL Service in Single User to shrink TEMPDB ... and realistically that is not an automatable task.And notwithstanding that just restarting SQL Service should, in normal circumstance and unless something has gone badly wrong, rebuild TEMPDB to its initial size etc.So ... scheduling a stop/start of SQL Service would effectively shrink it (assuming it isn't damaged, as per above, and if it is you will have to perform some one-time surgery to fix it anyway!) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
reduce the tempdb.mdb size automcatically