I am trying to reduce the size of the tempdb database
1. Stop Server Server
Net Stop MSSQLSERVER (Name of Services)
2. Net Start MSSQLSERVER /c /m /T3604
Bring up SQL Studio and DO NOT hit Connect, Just Hit New Query
--Check before I run statement
select (size*8) as FileSizeKB, * from sys.database_files ORDER BY TYPE DESC
This is size 184320 max size 209920
Even if I try to reduce it a little bit it will not allow me.
4: ALTER DATABASE tempdb MODIFY FILE (NAME = 'tempdev', SIZE = 184310 KB), MAXSIZE = 209910 KB)
This generates no error.
--Check it works nothing is changed, even after a restart of SQL Server
It did work as the original size was 1024 and I increased it and then decided to decrease it as I am just testing this out.
So the increase works, but the reduce in size doesn't allow.
Any ideas ?