how to find the files that the backup device has in sql server 2000?

• Mani-584606

  SSChampion

  Points: 11788

  More actions

  November 20, 2008 at 5:11 pm

  #196562

  Hi ,

  I have a confusion. The full,diff and log backups are going same backup device.

  Full 11:00pm diif every 6 hrs and log every 15mins. Now I have to restore the database from the backup device.

  1.If I choose

  Restore database ABC from disk='D:\ABC.bak'

  with norecovery,stats 10-> full backup will be restored.

  2.If i want restore Differential backup of ABC from backup device ABC.bak ( 5:00am) whatwill be the file number(I mean how to know the file number of diff backup at 5:00am)

  Restore database ABC from disk='D:\ABC.bak'

  with File = ?,norecovery,stats 10

  similarly how to know the file numbers of log backups taken every 15 mins?

  OR any other method we can use to restore from backup device?

  plz help me.

• MarkusB

  SSC-Dedicated

  Points: 37370

  More actions

  November 21, 2008 at 3:06 am

  #901510

  You can use RESTORE HEADERONLY to get the contents of a backup device.

  In the result look for a column called Backup_TypeDescription.

  RESTORE HEADERONLY

  FROM DISK = 'C:\myBackup.bak'

  [font="Verdana"]Markus Bohse[/font]