Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Backup & Restore Expand / Collapse
Author
Message
Posted Tuesday, December 10, 2013 8:00 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, March 31, 2014 9:00 AM
Points: 153, Visits: 573
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..!
Post #1521537
Posted Tuesday, December 10, 2013 8:02 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 11:47 AM
Points: 41,525, Visits: 34,442
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 2008, MVP
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

Post #1521539
Posted Tuesday, December 10, 2013 8:18 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, March 31, 2014 9:00 AM
Points: 153, Visits: 573
Thanks GilaMonster..!
Post #1521548
Posted Wednesday, December 11, 2013 5:10 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, April 14, 2014 8:19 AM
Points: 306, Visits: 461
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.
Post #1521839
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse