August 31, 2001 at 1:33 pm
The question I have is how to shrink a tempdb that is taking up about 5.3 gb of space on my server. I have attempted the shrink db function and it is not working. I have also stopped and started services and rebooted the entire server, but the space is still taken by tempdb. Any other thoughts?
September 1, 2001 at 9:04 pm
Hi there
Did you try:
dbcc shrinkfile
dbcc shrinkdatabase
I did this the other day and all worked a treat.
Cheers
Chris
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
September 2, 2001 at 10:31 pm
Try
DBCC SHRINKDATABASE (tempdb,10)
This will decrease the size of the files in the tempdb database to allow 10 percent free space in the files of tempdb
Deepak
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply