Restore database in sql server 2008 R2

Asked

Viewed 28 times

0

I have a file . Bak and while trying to restore I am using the following command:

use [master]
RESTORE DATABASE Teste FROM DISK='C:\Teste.BAK'

But sql returns me the following message:

Msg 3241, Level 16, State 13, Line 2
The media family on device 'C:\Teste.BAK' is incorrectly formed. SQL Server cannot process this media family.
Msg 3013, Level 16, State 1, Line 2
RESTORE DATABASE is terminating abnormally.
database sql-server
  • 1

    On which server was this backup done? Have you tried restoring it to the source server?

  • Solved!!! The . BAK file was generated on an SQL server 2012, and I was trying to raise the database on an SQL 2008.

No answers

Browser other questions tagged database sql-server

You are not signed in. Login or sign up in order to post.