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

Posted on 2007-10-03
Last Modified: 2008-03-24
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?

Question by:ainselyb
    LVL 13

    Accepted Solution

    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.
    LVL 6

    Assisted Solution

    Looks like you're restoring from SP4 to SP3.  Can you upgrade your version to SP3?
    check out
    LVL 6

    Expert Comment

    I meant to ask if you can upgrade to SP4

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    In this article—a derivative of my blog post (—I will explore a few different perspectives on which week today's date falls within using Microsoft SQL Server. First, to frame this stu…
    Performance is the key factor for any successful data integration project, knowing the type of transformation that you’re using is the first step on optimizing the SSIS flow performance, by utilizing the correct transformation or the design alternat…
    Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now