Printable View
I am unable to restore .bak file in sql server 2005 ,Although i took back up from sql server 2005 and restore in the same version,its giving me an error ...
does any one thing think that .bak is corrupted or whatever... please give me any remedy in that case ..I am also attaching .bak file too...any quick reply is highly appreciated ...
see image of error while restoring
does minor version of sql server 2005 effect on database restoring ??
maybe... I know that a backup from SQL2008SP1 cannot be applied to SQL2008 .... but usually in that case, you get a version error... your error is different. have you tried searching for that error?
-tg
i verify database using this
RESTORE VERIFYONLY FROM DISK='E:\downloads\rena.BAK'
but getting an error
Msg 3241, Level 16, State 0, Line 1
The media family on device 'E:\downloads\rena.BAK' is incorrectly formed. SQL Server cannot process this media family.
Msg 3013, Level 16, State 1, Line 1
VERIFY DATABASE is terminating abnormally.
well i have sql server 2005 at both time while taking back up and restoring....
secondly i did not found reasonable solution yet
Thanks
looks like a bad backup file then. I'd hazard a guess that something went wrong in the backup process.
-tg
so that means nothing can be possible to recover ...??