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.
RESTORE FILELISTONLY FROM DISK='\\Mylocation\DBRestores\MyBackupFile'
Cannot open backup device '\\Mylocation\DBRestores\MyBackupFile'. Operating system error 2(The system cannot find the file specified.).
Thanks