qbteachmt
Level 15

As I pointed out in my initial attempt to help you get your information, there are lots of resources on the web for the issue, if you want to "get technical" that don't need to be copied into a Tax Preparer End User community forum. I didn't realize it might be difficult to do the search for yourself, so I will offer some links and highlights here and you can pursue the links to read technical details and perhaps see other links:

https://flylib.com/books/en/3.174.1.26/1/

"The caveats for NAS are twofold. The architecture employed by NAS products does not lend itself to applications that are dependent on sophisticated manipulation of the storage media meaning any application that either has its own embedded file system to map and store data to the online storage directly, or that works with data management products, such as relational databases, which do the same. Secondly, applications that deal with highly volatile data do not perform well in other words, data that is subject to constant and continuous updating by a large user base."

Having a management utility can be helpful: https://www.cleartechnologies.net/network-attached-storage-nas-is-better-with-vsi/

"Network Attached Storage (NAS) is an exceptional solution for customers who wish to quickly and extensively share files within their network. The reasonable cost of NAS devices has led to expanding usage by organizations, and has led to the development of clustered NAS solutions by IBM and other storage hardware suppliers.

Regardless of the storage technology used, the need for storage continues to expand exponentially. Storage demand is primarily driven by unstructured data, which is defined as data that is not part of a relational database. NAS solutions are specifically designed for storing this type of unstructured data."

This document compares NAS and SAN; https://www.snia.org/sites/default/education/tutorials/2008/fall/applications/StephenDaniel_Running_...

And: https://community.spiceworks.com/topic/458814-for-a-sql-db-which-would-be-best-san-or-nas

To help understand that other solutions are available, and the history of NAS including the issue of corrupt DB. Another proposal as a make-it-work:

https://www.brentozar.com/archive/2012/01/sql-server-databases-on-network-shares-nas/

And interestingly enough, the gorilla in the room has this reference material: https://docs.microsoft.com/en-us/troubleshoot/sql/admin/support-network-database-files

Including: "Additional notes

Incorrect use of database software with a NAS product, or database use with an improperly configured NAS product, may result in data loss including total database loss. If the NAS device or network software does not completely honor data guarantees, such as write ordering or write-through, then hardware, software, or even power failures could seriously compromise data integrity."

I found a nice Q&A that helps with writes, torn pages, etc: https://dba.stackexchange.com/questions/78892/can-you-put-a-sql-db-on-a-nas

How heartbreaking is this: "The entire DB got corrupted, many files had a size of zero"

Now, obviously, if you are the programmer of Lacerte, you have more control for making it fault tolerant for NAS purposes or at the least, packeting the data in processible chunks. I am part of the Intuit Developers' Group and there is specifically a Lacerte SDK you can use, if you want to write an integration intermediary that provides gatekeeping to the NAS.

Group: https://proconnect.intuit.com/community/lacerte-sdk-group/gp-p/501 (a subset of this forum platform)

and the SDK resources:

https://developer.intuit.com/app/developer/lacerte-sdk/docs/lacerte-get-started

Hope that helps.

 

 

*******************************
"Level Up" is a gaming function, not a real life function.