Restore differential backup from device

• Ali Asghar Sharifi

  Mr or Mrs. 500

  Points: 526

  More actions

  January 8, 2007 at 12:44 am

  #118496

  Hello all

  I want to test differential backup strategy in my system.First I  take full backup and after few minute I take differential backup.When I restore those on  new database if I select from database option restore operation is performed successfully but when I select from device option and want to add two backup sqlserver show me this error message:  

  The volume on device 'D:\Backup\Bedis\bedis_diff_200701081025.bak' is not part of a multiple family media set. BACKUP WITH FORMAT can be used to form a new media set.

  RESTORE HEADERONLY is terminating abnormally. (.Net SqlClient Data Provider)

  Could everyone  help me?

• Minaz Amin

  SSChampion

  Points: 11052

  More actions

  January 8, 2007 at 2:11 am

  #681722

  Hi,

   

  This error message is an indication of media error. 

  check for the file name / device name spelled correctly  or the correct path is specified.

  Ran the following commands  RESTORE HEADERONLY FROM DISK='MyDatabase.bak'
   
  Check the following KB
   
  http://support.microsoft.com/kb/290787/en-us
  

   

  Investigate the following logs for more information:

  •
  SQL Server error log
  •
  Backup and restore history tables
  •
  Application event log
  •
  System event log

  Minaz Amin

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

• Ali Asghar Sharifi

  Mr or Mrs. 500

  Points: 526

  More actions

  January 8, 2007 at 3:46 am

  #681730

  Hi

  All of filenames and paths are correct.This error occure befor restoring database when

  i want to add two backup device to grid.

   thanks