Hello,
I have a pre-production environment running on Windows Server 2019, with a SQL Server Standard Edition 2019 database (version 15.0.4261.1).
I set up a test environment on Windows Server 2022, with a SQL Server Developer Edition 2019 database (version 15.0.2000.5).
I made a backup of the OIM (9.2) database from the pre-production server.
Before installing the One Identity Manager suite, I'm trying to restore this backup on the test server using SQL Server Management Studio.
However, when I attempt to restore the backup on the test server (using SQL Server Management Studio),
RESTORE VERIFYONLY FROM DISK = 'XXXXXXXXx\OIMxxxx.bak';
Msg 3203, Level 16, State 1, Line 3
Read on "XXXXXXXXx\OIMxxxx.bak'" failed: 38 (Reached the end of the file.)
Msg 3013, Level 16, State 1, Line 3
VERIFY DATABASE is terminating abnormally.
This command works fine on the pre-production environment (the source of the backup).
Am I using the correct method to restore an OIM database in a new environment?
Could this be due to the difference in Sql server versions (Standard vs Developer)? Or to the difference in operating system versions?
Where could this error be coming from?
Thank you for your insights.