SQL Express and NAS/SAN
Posted on 2009-02-19
OK, please answer this question for me. I have looked all over the Internet and can't find a best practice solution. There probably is no best answer.
The scenario is a six PC peer-to-peer network with an application on one computer that the users on the other clients access. The database is SQL Express. Everything works well. The person who owns the office wants to move the database and is going to purchase a Netgear RND 4425 NAS to put the database on. Most articles I have read have stated that while you can configure SQL on an NAS, it can be problematic and best practice would be SAN if one were not going to just use a Server/Client setup.
Given that the Netgear runs about $900, wouldn't it just make more sense to cough up a couple more grand and get a server. Even if it did do OK on the NAS, you would still have much more functionality with a server with Active Directory, etc.