| Author |
decrease initial database size
|
|
| Sorcerer 2006-10-24, 6:28 pm |
| 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)
| |
| Uri Dimant 2006-10-24, 6:28 pm |
| Hi
Can you restart SQL Server?
"Sorcerer" < Sorcerer@discussions
.microsoft.com> wrote in message
news:3443B8DE-A7F9-49A4-9EC9- EC7F7131947A@microso
ft.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)
| |
| Sorcerer 2006-10-24, 6:28 pm |
| 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@microso
ft.com...
>
>
>
| |
| Tracy McKibben 2006-10-24, 6:28 pm |
| 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 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)
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
| |
| Hari Prasad 2006-10-24, 6:28 pm |
| 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@microso
ft.com...[color=darkred]
> yes, but the file sizes are then set back to 80 (1) gb...
>
> "Uri Dimant" wrote:
>
|
|
|
|