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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-12-08 : 09:00:39
|
| Pradeep writes "how to release the free space in tempdb database (sql server 2005) to operating system without restrarting the sql server. I have tried using the dbcc shrinkdatabase(tempdb,0) only to recieve the following error message.DBCC SHRINKFILE: Page 1:4088048 could not be moved because it is a work table page.sp_spaceused command gives me 32gb of unallacated space." |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-12-08 : 09:16:41
|
| Have you gone through this:[url]http://support.microsoft.com/kb/307487[/url]Also, I would suggest instead of going for methods like DBCC ShrinkFile, try to re-write your queries/SPs to reduce the heavy usage of TempDB database.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
|
|
|
Releasing Free Space to disk from Tempdb