restore of last backup

• Tom Reis

  SSC Journeyman

  Points: 89

  More actions

  May 18, 2005 at 1:54 pm

  #163828

  Is there a way to restore the last backup with the RESTORE command line utility? I backup the database several times to the same device and need to use the RESTORE command to restore it but I want to restore the last backup that was done. Thanks.

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  May 18, 2005 at 2:21 pm

  #559711

  Run RESTORE FILELISTONLY  to get a list of the databases files and file numbers contained in the backup set.

  Then Run Restore command with FILE = file_numbes