2

Possible Duplicate:
SQL Server Files Local or NAS or SAN?

Hi,

I have just bought a NAS (NETGEAR Stora) for our home office - 2 Windows PCs.

I want to run a small database that both machines can access. I am building a c# winform app that is going to access it and I was hoping the entire database could reside on the NAS. Can you install SQL Server on a NAS? Is this possible or would one of the machines instead have to have SQL installed and then have the sql files on the NAS instead. The reason I was wanting to have the entire sql on the NAS was becuase then only the nas would need to be turned on and not have to rely on both the sql hosting pc and the NAS.

If it can be done how do i do it? Just point to the NAS during installation or...?

Any advice appreciated

thanks

Community
  • 1
kurasa
  • 121
  • 1
  • 1
  • 4
  • It's pretty obvious that this is not a duplicate. This question asks about running SQL Server inside a NAS, on its embedded host. The linked question is about running SQL Server on a stand-alone host machine, and deciding if the storage for the server would better be on a NAS or SAN. @splattne, how do we remove your duplicate tag – MikeB Nov 30 '19 at 21:45

3 Answers3

4

No. Your NAS is a 'dumb storage' device, not a server capable of hosting a piece of software like SQL.

As a storage device, it's also file-level rather than block-level (you cannot ask the device for only a small piece of a file, you have to take/put the whole file at once), which means you can't have concurrent access from multiple sources just by placing your data files onto the device. This is something you'd need a block-level file sharing system for (e.g. iSCSI/Fiber Channel SAN)

Chris Thorpe
  • 9,903
  • 22
  • 32
  • I agree in theory, but recently, the lines between traditional SANs and NASs are being blurred. More and more NASs support iSCSI and many SAN vendors are now support file-level services. The moral here I guess is that to support a SQL datastore, the OP needs block-level storage, not file-level, no matter what the "class" of the underlying device is. – EEAA Sep 04 '10 at 04:15
  • That's for sure. There's no consensus on the definition of SAN or NAS (or at least, the difference), which makes navigating that whole topic quite unpleasant. – Chris Thorpe Sep 04 '10 at 04:32
0

Already asked and answered:

SQL Server Files Local or NAS or SAN?

Community
  • 1
Rob Olmos
  • 2,220
  • 1
  • 15
  • 25
  • Do not post non-answers as answers. Post them as comments on the original question. Once you have enough rep, you'll be able to flag for closure. – EEAA Sep 04 '10 at 04:11
  • thanks. I read that link before I posted it recommends not to use a NAS but does not say whether it can be done or not which was my question. – kurasa Sep 04 '10 at 04:26
  • @ErikA Noted. Can you put that in the FAQ please? Should I delete this answer? – Rob Olmos Sep 04 '10 at 04:35
  • @kurasa I see. I recommend against as well with the NETGEAR Stora. Please note the related question in your question and why it doesn't fully answer your question. – Rob Olmos Sep 04 '10 at 04:38
  • @Rob - ???..."Please note the related question in your question and why it doesn't fully answer your question" - I thought my comment already did. It is a different question. It asks where to put the SLQ files (mdf, ldf) not whether the NAS can host SQL server which is what I am asking. Am I misunderstnding your comment to my comment in my question to your reference to the link of the other question? ...enough. I unsubscribe ;) – kurasa Sep 04 '10 at 04:51
  • @Rob why do you recommend against NETGEAR Stora? – kurasa Sep 04 '10 at 05:10
  • @kurasa Ohhh I understand now. I'm sorry :) Please see my new answer as it is easier to read there than as a comment. I don't recommend against the Stora itself, I've never used it so I can't say. Sorry for the confusion! – Rob Olmos Sep 04 '10 at 05:42
0

It is a different question. It asks where to put the SLQ files (mdf, ldf) not whether the NAS can host SQL server which is what I am asking. - kurasa

It looks like the only access you get to Stora is a web interface so I doubt you can install anything other than the packages they provide.

Secondly, most Netgear stuff runs Linux and actually if you look here:

http://kb.netgear.com/app/answers/detail/a_id/2649

You can see that the Stora (MS2110) has GPL code available to download. Upon inspecting it, it's all Linux so I doubt you can install SQL Server on it :)

Rob Olmos
  • 2,220
  • 1
  • 15
  • 25