Advice restoring .bak file on SQL server - stating wrong version

I am trying to restore a .bak file on Sequel server 2000.
I am getting an error stating tha it can't restore beacuse the version used to create the file (134218488) is different from my version (134219767).

Any advice?

Thanks.
ainselybAsked:
Who is Participating?
 
WizillingCommented:
what is the version of the server where the backup was made.
type select @@version to find out.

looks like the backup file you are restoring from is a higher version that was you are restoring to. Or it has a  recent serice patch installed.

backups cant be restored on lower version. it has to be equal or higer versions.
0
 
itdrmsCommented:
Looks like you're restoring from SP4 to SP3.  Can you upgrade your version to SP3?
check out http://sql-server-performance.com/Community/forums/p/8870/23208.aspx
0
 
itdrmsCommented:
I meant to ask if you can upgrade to SP4
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.