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 |
|
dpradeep
Starting Member
1 Post |
 Posted - 2006-12-07 : 00:12:55
|
| 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. |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-12-07 : 02:16:04
|
| There's no easy answer for this, you need to do the best you can to optimize tempdb so that it happens as little as possible, this article describes the best practiceshttp://www.microsoft.com/technet/prodtechnol/sql/2005/workingwithtempdb.mspx |
 |
|
|
|
|
|
Releasing free space in tempdb