[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

SQL Express and NAS/SAN

Posted on 2009-02-19
2
Medium Priority
?
430 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.
0
Comment
Question by:Bert2005
2 Comments
 
LVL 7

Accepted Solution

by:
Maeros earned 2000 total points
ID: 23688628
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.
0
 
LVL 1

Author Closing Comment

by:Bert2005
ID: 31548875
Thank you for your timely answer.
0

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

#Citrix #Citrix Netscaler #HTTP Compression #Load Balance
Microservice architecture adoption brings many advantages, but can add intricacy. Selecting the right orchestration tool is most important for business specific needs.
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question