Bert2005
asked on
SQL Express and NAS/SAN
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.
Any opinions.
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.
Any opinions.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER