This may seem easy but better to ask than mess up. Of course have now
seen the articles about adding files to the tempdb but none really indicate
the proper method for doing this they just say do it. Do I just right click
on Tempdb, properties, select data files and then just add the files and make
sure they are all the same size? I do not need to add more Log files just
the data files, correct? Once this is done does it require a restart of SQL?
This is also a SQL 2000 SP4 box with as SQL sees 8 processors. It does have
a TON of activity on it.
Thank you!
Inline.
"Transam388" wrote:
> This may seem easy but better to ask than mess up. Of course have now
> seen the articles about adding files to the tempdb but none really indicate
> the proper method for doing this they just say do it. Do I just right click
> on Tempdb, properties, select data files and then just add the files and make
> sure they are all the same size?
You can do this. I'd prefer to just run a series of T-SQL statements:
ALTER DATABASE tempdb ADD FILE (...)
> I do not need to add more Log files just the data files, correct?
Correct (unless you need more tempdb log space and the current log file
can't be grow any larger).
> Once this is done does it require a restart of SQL?
No.
> This is also a SQL 2000 SP4 box with as SQL sees 8 processors. It does have
> a TON of activity on it.
> Thank you!
No comments:
Post a Comment