November 17, 2006 at 11:06 am
Normally, when SQL Server start, tempdb will be re-created with default size. How to change the default size?
Many thanks in advance.
November 17, 2006 at 11:42 am
Pretty sure you just set it's size in Enterprise manager:
right click on tempdb in EM and choose properties....
Click the Data File tab; my db was defaulted to 8meg; changed it to 80 meg.
stopped and started the server (because tempdb is rebuilt on every start/stop)
checked it's size: still 80 meg i defined.
Lowell
November 19, 2006 at 9:41 pm
Thank you so much for your input. I thought tempdb would be created always with the default size, 8 MB.
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