Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Database & SysAdmin
  3. Database
  4. Error in Restoring SQL Server Backup of v 2012 to v 2008

Error in Restoring SQL Server Backup of v 2012 to v 2008

Scheduled Pinned Locked Moved Database
databasehelpsql-serversysadminannouncement
5 Posts 3 Posters 4 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • I Offline
    I Offline
    indian143
    wrote on last edited by
    #1

    Hi, I am getting following error message when trying to restore a Backup of Sql Server 2012 Database on a Sql Server 2008 Server, the error message says following:

    This error arises if you attempt to restore a database from a backup created on a later version of SQL Server to an earlier version of SQL Server. You can only restore to the same or a later version of SQL Server.

    Any help or suggestion would be greatly helpful, thanks in advance Thanks, Abdul Aleem "There is already enough hatred in the world lets spread love, compassion and affection."

    V L 2 Replies Last reply
    0
    • I indian143

      Hi, I am getting following error message when trying to restore a Backup of Sql Server 2012 Database on a Sql Server 2008 Server, the error message says following:

      This error arises if you attempt to restore a database from a backup created on a later version of SQL Server to an earlier version of SQL Server. You can only restore to the same or a later version of SQL Server.

      Any help or suggestion would be greatly helpful, thanks in advance Thanks, Abdul Aleem "There is already enough hatred in the world lets spread love, compassion and affection."

      V Offline
      V Offline
      Victor Nijegorodov
      wrote on last edited by
      #2

      Just install the SQL Server 2008 (Express edition = it is free!) and you'll be able to restore this DB. PS; check whether it was SQL Server 2008 or SQL Server 2008 R2.

      1 Reply Last reply
      0
      • I indian143

        Hi, I am getting following error message when trying to restore a Backup of Sql Server 2012 Database on a Sql Server 2008 Server, the error message says following:

        This error arises if you attempt to restore a database from a backup created on a later version of SQL Server to an earlier version of SQL Server. You can only restore to the same or a later version of SQL Server.

        Any help or suggestion would be greatly helpful, thanks in advance Thanks, Abdul Aleem "There is already enough hatred in the world lets spread love, compassion and affection."

        L Offline
        L Offline
        Lost User
        wrote on last edited by
        #3

        Read the message again; it is very clear on what is wrong and how to solve it.

        Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

        I 1 Reply Last reply
        0
        • L Lost User

          Read the message again; it is very clear on what is wrong and how to solve it.

          Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

          I Offline
          I Offline
          indian143
          wrote on last edited by
          #4

          It says but little confused about how is it going to resolve by just installing lower version - lol, thanks for helping for both of you. Thanks, Abdul Aleem "There is already enough hatred in the world lets spread love, compassion and affection."

          L 1 Reply Last reply
          0
          • I indian143

            It says but little confused about how is it going to resolve by just installing lower version - lol, thanks for helping for both of you. Thanks, Abdul Aleem "There is already enough hatred in the world lets spread love, compassion and affection."

            L Offline
            L Offline
            Lost User
            wrote on last edited by
            #5

            You can't restore a backup from a higher version on a lower version.

            Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

            1 Reply Last reply
            0
            Reply
            • Reply as topic
            Log in to reply
            • Oldest to Newest
            • Newest to Oldest
            • Most Votes


            • Login

            • Don't have an account? Register

            • Login or register to search.
            • First post
              Last post
            0
            • Categories
            • Recent
            • Tags
            • Popular
            • World
            • Users
            • Groups