I want to setup a database that has the data and log files on a different server on the network. How do I do this?
Carefully; I can't really generally reccomend the practice as part of a general production configuration. Testing that kind of configuration a few years ago (ver 7.0) with connectivity failure tests (with network storage devices) ruled out the practice for many uses. On some systems it seems to be enabled already, while on others it will require enabling a trace flag (as per MS - can't remember which one off hand) beforehand.