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 |
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2010-01-06 : 19:59:45
|
Hi I Have TEMPDB in the Instance which is growing as a result of the lengthy Job driven around several sp's and also the Datafiles MDF & LDF were also grown in its respective sizes, especially LDF in particular.Please advise me is it correct to shrink OR truncate the TEMPDB files?How to reduce OR trim the TEMPDB size .Thanks all. |
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2010-01-10 : 18:04:29
|
Thanks very much. Restart worked. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
X002548
Not Just a Number
15586 Posts |
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2010-01-14 : 17:37:34
|
Good Question. However, My TempDB got increased to the extent where it can fall, but all my DB Level LDF's were not increased. According to theory, when LDF gets to the HWM then automatically TEMPDB filled just because of some SP or batch process of DML, but in my case, it was not so.Any clarification to this anyone please? |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-01-15 : 03:05:45
|
"You can shrink it via DBCC SHRINKFILE"There used to be dire warnings about the circumstances when this was doable "online" (i.e. for TEMPDB), is that still the case (SQL 2008, say), or is it now "safe"? |
|
|
|
|
|