decrease initial database size

i've increased the initial database size of the tempdb to 80000 mb = 80 gb
and for the logfile of the tempdb to 1024 mb for testing purposes.
now i want to decrease the size back to 8 (1) mb but every time i do this in
the file propertys, the changes have no effect and are not stored. (even iv
the files are shrinked before)
how can i decrease the initial size of the tempdb and its logifle?
server: sql 2005 enterprise x64 sp1 (english)Hi
Can you restart SQL Server?
"Sorcerer" <Sorcerer@.discussions.microsoft.com> wrote in message
news:3443B8DE-A7F9-49A4-9EC9-EC7F7131947A@.microsoft.com...
> i've increased the initial database size of the tempdb to 80000 mb = 80 gb
> and for the logfile of the tempdb to 1024 mb for testing purposes.
> now i want to decrease the size back to 8 (1) mb but every time i do this
> in
> the file propertys, the changes have no effect and are not stored. (even
> iv
> the files are shrinked before)
> how can i decrease the initial size of the tempdb and its logifle?
> server: sql 2005 enterprise x64 sp1 (english)|||yes, but the file sizes are then set back to 80 (1) gb...
"Uri Dimant" wrote:

> Hi
> Can you restart SQL Server?
> "Sorcerer" <Sorcerer@.discussions.microsoft.com> wrote in message
> news:3443B8DE-A7F9-49A4-9EC9-EC7F7131947A@.microsoft.com...
>
>|||Sorcerer wrote:
> i've increased the initial database size of the tempdb to 80000 mb = 80 gb
> and for the logfile of the tempdb to 1024 mb for testing purposes.
> now i want to decrease the size back to 8 (1) mb but every time i do this
in
> the file propertys, the changes have no effect and are not stored. (even i
v
> the files are shrinked before)
> how can i decrease the initial size of the tempdb and its logifle?
> server: sql 2005 enterprise x64 sp1 (english)
You need to restart SQL in a "minimum configuration" mode by using
sqlservr -c -f
Connect to this running instance using Query Analyzer and use the ALTER
DATABASE command to set the size of the TEMPDB data and log files.
Restart SQL normally, and you should have a new properly sized TEMPDB.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Hi,
Have a look into this article to shrink tempdb
http://support.microsoft.com/defaul...kb;en-us;307487
Thanks
Hari
SQL Server MVP
"Sorcerer" <Sorcerer@.discussions.microsoft.com> wrote in message
news:4F72AAFF-4C4C-452E-B752-2E4C6588D2C8@.microsoft.com...[vbcol=seagreen]
> yes, but the file sizes are then set back to 80 (1) gb...
> "Uri Dimant" wrote:
>