I have a backup file that I need to restore daily on schedule based.
But the backup file is from SQL Server 2008 and restore destination is SQL Server 2014. And also the backup file is from cross network. I have copied to local shared folder and trying to restore it.
The code I used:
USE [master] RESTORE DATABASE MyDB FROM DISK = N'\\Mylocation\DBRestores\MyBackupFile' WITH FILE = 1, -- 1 = .bak, 2 = .trn type backup MOVE N'MyDB_data' TO N'S:\MSSQLsql\mssql\DATA\MyDB.mdf', MOVE N'MyDB_log' TO N'L:\MSSQLsql\mssql\DATA\MyDB_log.ldf', NOUNLOAD, STATS = 5 go
but I get an error
Msg 3241, Level 16, State 0, Line 3
The media family on device '\Mylocation\DBRestores\MyBackupFile' is incorrectly formed.
SQL Server cannot process this media family.
Msg 3013, Level 16, State 1, Line 3
RESTORE DATABASE is terminating abnormally.
Any help? thanks.