We help IT Professionals succeed at work.

SQL Express and NAS/SAN

Medium Priority
457 Views
Last Modified: 2012-05-06
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.
Comment
Watch Question

Commented:
Putting a live database on a NAS is not recommended.  NASes are designed primarily for file and backup storage.  They are not meant for high availability, nor high performance.  They are far slower and more burdensome to deal with than a server.

If you wish to use a NAS to back your database up to then that is feasible, but as far as live is concerned it is not best practice.  You will run into noticeable slowdowns and issues.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
Thank you for your timely answer.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.