Microsoft SQL Server uses a particular collation type to store the database file. Generally, collation is a set of rules to determine how data is sorted and compared. In this MDF Database Recovery Pro software, you get two options to define the collation type: Auto-detect Collation:- If you don’t know what your collation type is, you should choose the Auto-detect option. This will help the software detect the correct collation type used in your MDF database. Define Collation Type Manually:- If you know the correct collation type used in your MDF database, you should choose this option and define the collation type. Keep in mind that if the software fails to detect the correct collation type automatically, you have to define it manually.