I have a 2008 server that I'm trying to migrate over to a 2019 server. After generating my .bak file from 2008 and verifying via 'Restore VerifyOnly', I'm running into a wall when attempting to restore this into the 2019 server.
The error messages I am receiving with various troubleshooting commands are as follows:
Restore Database DB from disk='C:\temp\Backup.bak'
Msg 3287, Level 16, State 1, Line 4
The file ID 1 on device C:\temp\Backup.bak' is incorrectly formed and can not be read.
Msg 3013, Level 16, State 1, Line 4
RESTORE DATABASE is terminating abnormally.
On the 2019 server:
Restore VERIFYONLY from disk='C:\temp\Backup.bak'
Msg 3242, Level 16, State 2, Line 4
The file on device 'C:\temp\Backup.bak' is not a valid Microsoft Tape Format backup set.
Msg 3013, Level 16, State 1, Line 4 VERIFY DATABASE is terminating abnormally.
Running a 'Restore Headeronly' produces "INCOMPLETE" under the backup name and subsequent NULL values. Is there a way I can get this data migrated from 2008?