sharepoint / nas / sql config

[billb]

Hi,

We currently store all files on a nas box and are looking at getting sharepoint. if i get a new server for sharepoint can I put sql on the nas box ok and run the sharepoint database from this ok? I presume sql can go on a nas box ok dont really know sql that well?

Any advice appreciated thanks

[Don]

A SQL database consists of:

a) A service that waits for SQL requests running on a computer somewhere, it accepts the requests and then processes them

b) A large proprietary data file that contains the data

Whilst a NAS is a computer I do not believe you will be able to run (a) above on it. You can, of course, store (b) on a NAS.

If you do, however, you will create a truly VAST amount of network traffic between (a) and the NAS containing (b). Typically (b) is stored on a hard disk in the same computer that is running (a)...for a good reason.


Again - typically - You put the SQL server's data files on the same box as runs the service...and simply back up to the NAS.