SQL Server Files Local or NAS or SAN?
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