File Appears To Have Been Truncated By The Operating System.

[iain1993]

Hello.

Are there members who use SQL Server? There's a MDF file that I could open on Portatil HP Notebook 15-ba033ns,on Windows 8.1. However, after the Windows 10 update, I suddenly can't open it anymore. It gives the following message, File Appears To Have Been Truncated By The Operating System.

I googled for this, i get many solutions for all other databases except mdf file issue. Can someone help me?

Thanks in advance.

[dylan1994]

You’d need to install some version of SQL Server, then re-attach the MDF file. However, if you don’t have the matching LDF file (the log file), you don’t have the whole database. Because of this, an MDF file is not the correct way to transfer databases between servers. Instead, you need to make a backup using SQL Server Manager, then restore the backup on the other server. If you need more information take  a look here: how to open mdf file?