Restoring Differential backup

• sarita Garg

  SSC Eights!

  Points: 824

  More actions

  August 13, 2003 at 2:16 pm

  #160549

  I am taking a full backup and differential backup on production server.

  I need to bring these two backup files on to development server and restore them.

  Database names are the same on both production and development.

  I used the following script:

  -- Full backup restore

  RESTORE DATABASE test

  FROM DISK = 'd:\mssql\backup\test_bkup.bak'

  with norecovery

  -- Differential backup restore

  RESTORE DATABASE test

  FROM DISK = 'd:\mssql\backup\test_DIFF_BACKUP.bak'

  WITH FILE = 2,RECOVERY

  Full backup restores successfully. But differential backup restore gives me error"

  Server: Msg 4038, Level 16, State 1, Line 1

  Cannot find file ID 2 on device 'd:\mssql\backup\test_DIFF_BACKUP.bak'.

  How do I get around it so that I can restore both full and differential backup files of production onto development.

  Thank you for your help.

• 5409045121009-7368

  SSCoach

  Points: 15740

  More actions

  August 13, 2003 at 2:21 pm

  #469812

  I think remove "WITH FILE = 2" from the second restore

  BOL: FILE = { file_number | @file_number }Identifies the backup set to be restored.

  Assumption you backuped each backup to a different file.