Restoring .bak files in sql server

Question

I got this error while restoring a .bak file. any one help to resolve this error

Answer 1

looks not good.

are you sure that dynamics.bak is a SQL Server backup ?

are you using the same or higher version than the backup file is coming from?

use the following statement on both servers to get version number

select @@version

Answer 2

hi,

Are you trying to restore a backup made on a newer version than the one you are restoring? Database backups are not backward compatible, eg: you cannot restore a backup created on SQL 2008 to SQL 2005

I hope it helps.

Janos

---

There are 10 type of people. Those who understand binary and those who do not.
My Blog

Answer 3

Hello,

As mentioned in another reply, remember that SQL Backups are not backward compatible. 

If you are trying to restore to the same or newer sql version and you get this error, the BAK file could be corrupted

you can check it using below code

RESTORE VERIFYONLY FROM DISK = "C:\FILE.BAK"

http://msdn.microsoft.com/en-us/library/ms188902.aspx

---

Javier Villegas | @javier_vill | http://sql-javier-villegas.blogspot.com/

Please click "Propose As Answer" if a post solves your problem or "Vote As Helpful" if a post has been useful to you

Answer 4

Thank you daniel, that was a version problem only.