Post reply

Backup & Restore

  • December 10, 2013 at 8:00 am

    #395965

    I am trying to restore SQL 2012 backup on SQL 2008 R2 & it troughs an error.

    Error: No backupset selected to be restored

    Please help. Thanks..!

  • December 10, 2013 at 8:02 am

    #1672330

    You can't restore down-version. A SQL 2012 backup can only be restored to SQL 2012 or newer.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • December 10, 2013 at 8:18 am

    #1672339

    Thanks GilaMonster..!

  • December 11, 2013 at 5:10 am

    #1672574

    Ranzz (12/10/2013)

    I am trying to restore SQL 2012 backup on SQL 2008 R2 & it troughs an error.

    Error: No backupset selected to be restored

    Please help. Thanks..!

    If it is something you need to do you could extract the DDL for the database and load the data into it using BCP.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply