Hey everyone, I'm in the process of setting up a centralized file storage system for our company, which has around 70-80 employees. Most of our documents are Excel files, PDFs, and QuickBooks files. The plan is to use SharePoint through Microsoft 365 for storing department folders like HR and Accounting. Everyone would be able to access files via SharePoint or Teams. When we hit our storage limit of 1TB + 10GB per user, we would offload older files to Azure Storage for long-term storage. I think this will keep everything centralized and integrated within our Microsoft environment, and Azure can serve as a scalable backup or archive solution. I'm looking for feedback on a few questions: Is this setup practical for our company size? How does SharePoint handle daily file access, especially for QuickBooks and large Excel files? Is Azure File Storage easy to set up for non-developers, just IT staff familiar with Office 365? Are there better alternatives or any potential issues I should consider? I appreciate any real-world experiences or recommendations before I finalize my plan.
3 Answers
If you're thinking about using SharePoint for QuickBooks files, you might want to rethink that. QuickBooks requires a specific setup and performance that cloud storage like SharePoint or Azure Files can't provide. It expects LAN-level access, which you won't get over the internet. If you need to use QuickBooks, it would be better to keep those files locally or synced via OneDrive for single-user mode. For your other file types like Excel and PDFs, SharePoint should work fine, but be cautious with the number of files you sync; hitting 100,000 files can create sync issues.
Based on what I've heard, QuickBooks should really use Azure Files—preferably Azure NetApp files. SharePoint might not be viable for those kinds of documents. Either way, you'll want to ensure you're set up correctly with your storage solutions.
Just a heads-up, I wouldn't reach out to me for private messaging. But about your setup, I'd suggest focusing on the performance requirements for QuickBooks. You might need Azure Files with Premium options if you plan on using it in a cloud environment. It’s critical to ensure that the storage solution aligns with what your applications need.
Related Questions
How to Build a Custom GPT Journalist That Posts Directly to WordPress
Fix Not Being Able To Add New Categories With Intuitive Category Checklist For Wordpress
Get Real User IP Without Installing Cloudflare Apache Module
How to Get Total Line Count In Visual Studio 2013 Without Addons
Install and Configure PhpMyAdmin on Centos 7
How To Setup PostfixAdmin With Dovecot and Postfix Virtual Mailbox