I'm trying to restore a SQL Server database from a .bak file. The process completes without any issues, but the dates with datatype datetime2 are presented with totally different values (change to future dates, e.g. I see dates 1/1/4014). The source backed-up database collation is Cyrillic_General_CI_AS. The login user has been set to have English-us and Russian language but the same issue persists in both cases. Other types of data, e.g. float numbers, are ok (and readable), only dates are affected.
What exactly is the issue here and can it be resolved? Is there a specific step we missed and we need to configure?