Location of database and log files

We are beginning a new implemenation of SQL2000 and considering the locations
of the database and log files. Am I correct that the Log files must reside on
the same server as SQL? Is performance effected at all if the database file
resides on another server?Well - think what would happen if you lost the other server or even if you
lost network connection.
It's not a good idea. :(
"SeaBob" <SeaBob@.discussions.microsoft.com> wrote in message
news:B5C2383C-D301-4096-8C74-9247CBEE6F75@.microsoft.com...
> We are beginning a new implemenation of SQL2000 and considering the
locations
> of the database and log files. Am I correct that the Log files must reside
on
> the same server as SQL? Is performance effected at all if the database
file
> resides on another server?|||Data and log files can and should be split across multiple volumes or
devices on a server (either direct-attached or SAN storage) but those
devices must be attached to the server that is running SQL.
In certain very restricted circumstances and on certain hardware only NAS
storage is supported but this is definitely not recommended other than in
exceptional cases.
Installation of databases on a remote server is not supported, nor would it
be a desriable or sensible thing to do from the point of view of
architecture, performance, resilience or data-integrity.
--
David Portas
SQL Server MVP
--