Thanks for the suggestion mph999,
So I did that and I can see the largest file (in my case 837.dat) being 10MB in total. The second largest file (854.dat) is 7MB, then this is followed by five more files of approx. 3.5MB and the rest is literally just few KB where the total number of dat files is 230 with total size of 40MB.
Here are the "reload.sql" references to the 837 and 854 dat files:
-----------------------------------------------------------------------------------------------------------------------------------------------
INPUT INTO "DBM_MAIN"."DBM_Image"
FROM 'S:/1/837.dat'
FORMAT TEXT
ESCAPE CHARACTER '\\'
BY ORDER("ImageKey","MasterServerKey","PreviousBackupImageKey","ParentImageKey","CatArcImageKey","FullBackupImageKey","CSScheduleKey","ClientMachineName","ClientKey","PolicyName","BackupTime","ViewID","ScheduleType","ClientType","ProtocolVersion","StartTime","EndTime","SnapTime","KiloBytes","NumberFragments","NumberCopies","NumberSnapshotDevices","ImageVersion","RetentionLevel","Compression","Encryption","FilesFileCompressed","Mpx","TirInfo","TirExpiration","PrimaryCopy","ImageType","ElapsedTime","Expiration","NumberFiles","ExtSecInfo","RequestPID","IndividualFileRestoreFromRaw","ImageDumpLevel","FileSystemOnly","PrevBlkIncrTime","BlkIncrFullTime","StreamNumber","BackupCopy","BackupStatus","JobID","NumResumes","ResumeExpiration","PfiType","ImageAttribute","Creator","ScheduleName","ProxyClient","KeywordPhrase","FilesFile","FilesFileSize","SoftwareVersion","ObjectDescriptor","EstimatedKiloBytes","VmType","IsSynthetic","RunTime","LastBirthTime","ClientCharacterSet","BmrInfo","OriginMasterServer","OriginMasterServerID","StorageServiceName","StorageServiceState","StorageServiceIndexOffset","StorageServiceIsInactive","TimeInProcess","ClassificationID","StorageServiceVersionNumber","RequiredExpirationDate","ImportFromReplicaTime","IrEnabled","IsQuiesced","SLPOperationsMask","IsScheduled","HasDependees","HasDependents","ValidationCount","ExpirationCount","IndexingStatus","NumChildren","DumpHost","KiloBytesDataTransferred","AppType","CreatedDateTime","LastModifiedDateTime","ProviderGeneratedId")
ENCODING 'UTF-8'
go
-----------------------------------------------------------------------------------------------------------------------------------------------
INPUT INTO "ADTR_MAIN"."ADTR_AuditRecord"
FROM 'S:/1/854.dat'
FORMAT TEXT
ESCAPE CHARACTER '\\'
BY ORDER("AuditRecordKey","MasterServerName","UserName","UserDomain","UserDomainType","AuditTimestamp","MessageId","Category","Operation","NumPHs","NumNVTs","TieInId","Reason","MetaData","RecordId","ParentRecordId","CreatedDateTime","LastModifiedDateTime")
ENCODING 'UTF-8'
go
-----------------------------------------------------------------------------------------------------------------------------------------------
![]()
Cheers