How to change SQL Server Tempdb initial size?

I need to change Tempdb intial size from 8 mb to 200 mb and 10%  unlimted auto growth using script. Please send me the script. And also let me know do i need to restart the sql server services to update this changes.Thanks.
PKTGAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

k_murli_krishnaCommented:
Here are some excellent articles.

Minimize the size of tempdb in SQL Server
http://articles.techrepublic.com.com/5100-10878_11-6128110.html

How to shrink the tempdb database in SQL Server
http://support.microsoft.com/kb/307487

Tempdb Configuration Best Practices in SQL Server
http://www.mssqltips.com/tip.asp?tip=1432
0
Anoo S PillaiCommented:
The following script would help you to achiive the task
Execute the below script and restart the Sql server service. Please replace the file parh with the relevent path in your instence. I assume that you are asking only to resize your TempDB datafile. If you need to resize your log file append the sctipt with the log file settings.

use master
go
alter database tempdb
modify file (name = tempdev, filename = '<File Path>\tempdb.mdf',
size = 200 ,FILEGROWTH = 10%)
go

 
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.