The file migration list should consist of all the files which are present in your database irrespective of whether they are in active use or not. This is because some files which are not an active use might be important because they contain essential historical records and if they are not mentioned in the migration list, there is a good chance that they will not be transferred and hence you will lose an important aspect of your business.
Why Businesses Lose Data During File Server to Cloud Migrations

The migration displays complete on the screen. But when a user in Finance opens the SharePoint, the files aren’t there.
Have they been irreversibly deleted? Perhaps not.
There may be a variety of reasons: they weren’t involved in the migration, the user does not have access, or the file has been migrated and is present online but is not visible to them locally through File Explorer.
Every single one of these will need a different resolution. Verify what’s creating the issue before decommissioning the legacy server.
What you’ll learn:
- Files That Never Made the Migration List
- Why Cloud Files Look Missing in File Explorer
- How Migration Settings Leave Documents Behind
- When Permissions Make Files Inaccessible
- The Danger of Working in Two Locations
- How to Check Every Critical File Arrived
- Wrapping It Up
Files That Never Made the Migration List
If you’re not sure of the existence of a file or folder, it won’t be transferred.
File servers have a habit to collect many shared drives and folders over time, including folders that are no longer in active use but may consist of important historical records, as well as folders only a small number of users know about.
If these are not verified and inculcated in the migration plan, you increase the risk of damaging important files.
As part of pre-migration preparation, you should list a complete inventory of source locations and needed data. This should have:
- All shared drives and folders, and any business owners
- Older or legacy records needed
- Any access limitations and permissions
- Intended target location for every set of file
You may also see that some files do not require migrating, or should be retained as an archive or removed according to your data retention rules.
Based on the kind of files, you may migrate a few to SharePoint Online while others sit in OneDrive.
Why Cloud Files Look Missing in File Explorer
Once the files have been migrated to SharePoint, some users may still need to search for them in their local File Explorer, as they would with a standard file server.
Confusion can quickly ensue.
If your users wish to keep using File Explorer to navigate to files, understand how to sync SharePoint to File Explorer. OneDrive permits users to sync SharePoint document libraries to their local File Explorer, but this should not be confused with offering file server functionality.
Likewise, make sure that the user has Files On-Demand configured the right way under Sync and backup in their OneDrive settings to permit them to opt-in or out of syncing files to their local device to reduce disk space. With Files On-Demand enabled, files will be visible in File Explorer but the file itself will only be installed to the user’s device once they open it.
If a user requires to have a file permanently accessible to them offline, they can choose ‘Always keep on this device’ through right-clicking on the file and permit it to completely download. Ensure the user knows that they will need an internet connection to open files if they are not completely downloaded to their device.
Also verify whether the user has chosen to sync the SharePoint folder to their File Explorer.
As a rule of thumb, move to the file in SharePoint directly. If it’s there, troubleshoot the user’s OneDrive connection, signed-in account, folder selection and file status.
How Migration Settings Leave Documents Behind
It’s also not a surprise that one or more files may have been kept out from the migration.
This may happen for multiple reasons, such as the route length, invalid file name, source location inaccessible, corrupt file etc. If a folder is not capable of migrating, it is likely that all files included within it will also fail.
Microsoft’s SharePoint Migration Tool offers the option to carry out a pre-migration scan and consists of filters to exclude files depending on date and file type, as well as settings to replace invalid file name characters and quantity of file versions to migrate.
For instance, if you have set the file date filter to not include older files, a legacy vendor contract may be excluded – even though it might still be a live contract. Or if you have selected to migrate a restricted number of versions, you may only migrate the recent file version.
Perform a pre-migration scan and examine the output for any excluded files or failed items. Update as necessary and re-run the failed items. Register any intentionally kept out files to prevent them from being flagged as missing in the future.
When Permissions Make Files Inaccessible
In a few cases, the file will be available in SharePoint Online, but a user is not able to access it.
You may have a file-server permissions version that pairs NTFS permissions and Active Directory groups. However, the equivalent version might not translate to SharePoint.
Microsoft lists that a few NTFS permissions will not be moved across, including explicit deny rules. As a result, you may offer SharePoint Online to either insufficient or more permissions than what was necessary.
Make sure that you test the target permissions with representative users, instead of just with administrator accounts. Also inspect that users are not able to view any restricted locations.
If a user can’t open a file due to restrictions, it will need remediation of permissions and not re-migration of the file.
The Danger of Working in Two Locations
While a migration occurs, it’s possible that a few users continue to perform activities on the legacy file server, while others start to work on files in SharePoint Online.
This will ultimately lead to various versions of a file being built. If the file server is then decommissioned, the recently modified files will be ‘lost’ on the legacy server.
This is a disadvantage to be mitigated when thinking about the cutover to SharePoint Online, even if the starting file migration is carried out successfully.
A lot of organisations face different levels of disruption as a result of a data migration, with 24% of respondents strongly agreeing that they had witnessed extended unplanned downtime as a result of data migration as per S&P Global Market Intelligence’s 451 Research in August 2026. This is not restricted to data loss or file migrations to SharePoint.
Check for this with a phased procedure – initially migrating a few of the files and users, then transferring the remaining files and users in multiple tranches. Communicate the point at which SharePoint Online is the ‘only source of truth’ to all users, cease modifications to the legacy server during the migration and look for any outstanding changes.
Maintain the legacy server or a recoverable copy until you are assured that all data has been moved. Be mindful that a OneDrive sync alone is not a type of data backup because deletions in a synced folder can also be shown in SharePoint Online.
How to Check Every Critical File Arrived
Before decommissioning the legacy file server, you should think about the following:
- Verify your source inventory with the target data locations to confirm all files are available. Don’t simply depend on the total number of files migrated.
- Check files and folders that were unable to migrate or were excluded in the pre-migration and post-migration reports. Rerun them or document why they were intentionally kept out.
- Open files to review that they are present and available. This should consist of key files in-scope for your migration.
- Verify access with representative end-user accounts and ensure that they have files available offline where needed.
- Validate any outstanding file changes have been moved and recommend users to keep any new files in the relevant target location.
Work with your business owners to look for any key files that they can verify. For instance, Finance may be able to tell you about particular files and folders that they know should be present.
Enforce a method for users to raise any missing or inaccessible files following cutover, and do not decommission your legacy file server or backup till the time you have received sign-off and confirmed a backup and recovery plan is in place.
Wrapping It Up
Many businesses often believe they have lost documents after a file server migration, only because they have not carried out the steps above to check the completeness and usability of their migrated data.
Take time to plan a specified inventory of your source files, be aware of the issues outlined above and handle your cutover to SharePoint Online, testing with your end users to confirm success.
Finally, the aim of migrating from a file server to SharePoint Online is to offer users with continued access to their business data.
Frequently Asked Questions
What should my file migration list include?
How do I ensure that all the files have migrated from my old system?
This is one of the most common mistakes which people make while migrating their files. Some files do not get transferred to your new system because of multiple issues like invalid file name or some filters which you applied and that is why you should always perform a pre-migration scan and look for any excluded files in that test run. This will tell you what files you need to look at for their availability after the migration has been done to ensure that you do not lose important documents.
Why does my file have multiple different version?
A file has multiple different versions to it if after migration some users use a different platform and other users use the legacy server. To avoid this, always migrate your files in batches and once the entire migration is successful, give out notifications to your user telling that the new platform is the one which they should use to store their information otherwise the loss of their information will not be your guarantee.
Nowadays, students, parents, and professional learners are turning to AI tools for different purposes, such as recommendations; education providers need…
An air gapped environment sounds secure simply because it has no internet connection, but keeping data isolated involves more than…
Most of the growing businesses has one spreadsheet that holds the operation together. It might track orders, jobs, inventory, or…
Data sanitization is the permanent, irreversible removal or destruction of data stored on IT hardware and memory devices so that…
Scrapers are a well-known problem for businesses; protecting private records, discouraging unwanted bulk copying, and preserving access are topics one…
People who read about data recovery are most likely to think hard about the place where the files can go.…
The ownership argument between both kinds of suppliers never ends. The sentence costs nothing to say, but blindly trusting that…
A stolen laptop can expose far more than the device itself. Your documents, work files, photos, and personal information may…
Even with polished checkouts, online stores can still have trouble getting secure, suitable payments. The process is more complex than…








