 Re: cluster and tempdb on c:\ -
03-28-2008
, 05:59 AM
It is a good idea to have tempdb on a separate disk from your data.
However, in a clustered system, any data or log files *must* be on a
clustered drive - not a local one.
--
Tom
----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Leon McCalla" <leonmccalla (AT) drop (DOT) hotmail.com> wrote
I'm trying to boost SQL server 2000's speed at running some of my long
queries.Is it a good idea to put the tempDB on a physically separate HD
subsystem in the interest of speed? I want to do this but......
Server: Msg 5184, Level 16, State 1, Line 1
Cannot use file 'c:\MSSQL\data\tempdb.mdf' for clustered server. Only
formatted files on which the cluster resource of the server has a dependency
can be used.
since hte temp DB is re-created every time SQL starts, this should not be a
requirement. Any thoughts???
Leon
|
Linear Mode
