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

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,953
  • 25
  • 33
0

Already asked and answered:

SQL Server Files Local or NAS or SAN?

Community
  • 1
Rob Olmos
  • 2,250
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,250