Restoration Error

• Chand00

  SSCertifiable

  Points: 6466

  More actions

  August 9, 2007 at 10:50 pm

  #69045

  Dear All,

     I have a problem in restoring the databases onto a standby server with the recent full backup and diff backup as the recovery model is simple. The error message i get is

  1. "Cannot associate file with different databases."

  2. "Cannot apply the backup on device --- to dabase 'xxxx'

  3. Log file ---- does not match the primary file. It may be from a different database or the log may have been rebuilt previously.

  Thanks & Regards

  Chandra Mohan N

   

  [font="Verdana"]Thanks
  Chandra Mohan[/font]

• Minaz Amin

  SSChampion

  Points: 11052

  More actions

  August 10, 2007 at 5:05 am

  #725949

  The above error clearly states that the log file is not matching . Please check the backup file with :

  RESTORE FILELISTONLY command.

  Please refer BOL om Simple recovery model.

   

  Minaz

  "More Green More Oxygen !! Plant a tree today"