• Thom A - Monday, December 11, 2017 12:31 PM

    Does anyone use a NAS at home? Anyone able to recommend an affordable 2 Bay for home use? I recently picked one up, and (for some reason) the minimum file allocation size was set to 128MB. As you can guess, a 3TB array ran out of space quite rapidly after I copied a large volume of small files over. Support says it's "by design". Not sure how it can be, the box says it can hold about 2.7M photos, however, at 128MB each, that storage can't hold much more than 8,000 files... Heh.

    Sending the one I have back for a refund once the factory reset is down, but the external HDD is getting very old, so little concerned it could fail some time in the not too distant future. O.o

    I'm thinking about getting this one: https://www.amazon.com/NETGEAR-ReadyNAS-Performance-Processor-RN42200-100NES/dp/B015S0Y50C/ref=sr_1_2_sspa?s=pc&ie=UTF8&qid=1512679433&sr=1-2-spons&keywords=NAS&th=1

    And here are some drives to put into it: https://www.amazon.com/s/s/ref=sr_nr_p_n_feature_three_br_0?fst=p90x%3A1%2Cas%3Aoff&rh=n%3A1292110011%2Ck%3Assd%2Cp_n_feature_three_browse-bin%3A6797522011&keywords=ssd&ie=UTF8&qid=1512680537&rnid=6797515011

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes


    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2