If we assume that this record is encrypted or compressed, Is there a way to show how the records with this problem were encrypted? What encryption or compress method?

Through the this content SQL Server - BLOB Import and Export[^] and How to store and fetch binary data into a file stream column[^] , I was able to retrieve the blob from the FileImage column. But it doesn't work for some records. In other words, it opens with an error for this type of file that has been fetched. Table structure:

CREATE TABLE [dbo].[Attches](
[AttchID] [int] IDENTITY(1,1) NOT NULL,
[FileType] [varchar](30) NOT NULL,
[FileSize] [int] NULL,
[FileImage] [varbinary](max) NULL
)

I tried to extract a damaged document or pdf file in raw form and opened it with Hexinator software. All the file that is corrupted, first its hex starts with the path of the file. In other words, it is manipulated. Is there a way to retrieve data safely? Best regards