database restore

• ahmedmujtaba88

  Old Hand

  Points: 349

  More actions

  January 16, 2012 at 12:05 am

  #73138

  Hi can anyone please help me for my question .

  Previously i was using SQL SERVER 2008 R2 and now i have removed 2008 R2 and i installed SQL SERVER 2012 RC0 . And i took the backup of my 2008 R2 databases and when i m trying to restore the same backup files on respective databases(2012 RCO) then i m getting an error which i mentioned below

  Error 3154: The backup set holds a backup of a database other than the existing database.

  Thank you ..

• padhis

  SSCommitted

  Points: 1762

  More actions

  January 16, 2012 at 12:16 am

  #1433906

  Use WITH REPLACE in the RESTORE command.