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
I think that error code of 3241 indicates a backwards compatability issue. Are you sure the backup was created with the same or earlier version of SQL server than the one you are attempting to restore onto? Note that service packs can be applied to one instance and not the other, so make sure you have the latest SP installed on the instance you are restoring to (I think 2005 had a service pack 3 from memory, possibly more??)
Hope this helps :)
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.
