Hi guys,
On my SQL Server the tempDB is 4 GB, with basically 100% of that available. I have tried to shrink the database (via the properties dialog) but it has not changed the size. Any ideas on other possible approaches?
Thanks
Declan
Printable View
Hi guys,
On my SQL Server the tempDB is 4 GB, with basically 100% of that available. I have tried to shrink the database (via the properties dialog) but it has not changed the size. Any ideas on other possible approaches?
Thanks
Declan
You cannot shrink a database file to less than its minimum size. The minimum is the allocated size when the DB was created or the last time the file size was set (ie if the the file is allowed to automatically grow that becomes the new minimum).
On the Shrink Database dialog there is a button called Files that brings up another dialog. There is an option to Shrink File to a new minimum size.
Bruce
Once again thanks for the help. This is perfect, tahnks.
I just wish I could rep you again - but I need to spread some love first ;)