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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy