I'm seeking advice on how to handle my organization's file storage system. We switched from a traditional on-prem file server to OneDrive and Teams with SharePoint about a year ago, but now we're facing a major issue. We're currently sitting on nearly 1 million files in one SharePoint site, far exceeding the recommended limit of 300,000. I plan to present this problem to our leadership, but I need to suggest a practical solution. I'm considering Azure Files, but my IT manager has concerns about offsite users needing to use a VPN for access. Additionally, the end-users have expressed a preference for keeping the file explorer interface consistent. What alternatives or solutions can I propose to effectively manage our files?
1 Answer
You definitely don’t want users syncing those huge SharePoint libraries; that's just a recipe for sync issues. SharePoint isn't designed to function as a traditional file server without some workflow adjustments. If you're looking at Azure Files, keep in mind there are alternatives. A colleague of mine has had great success using MyWorkDrive. You can put your files in Azure storage, install MyWorkDrive, and your team can access everything without needing to connect via VPN.
A lot of people are syncing it, and they are definitely having issues. I’ll look into separating into different sites. Thanks for the suggestion about MyWorkDrive!