Restore most current backup.

• uncle_enzo

  Mr or Mrs. 500

  Points: 573

  More actions

  July 3, 2008 at 8:50 am

  #124492

  Hi, I have a server that keeps 3 days of full backups on disk. Occasionally I need to restore the most current full backup in test and dev. Backup files are named like this

  "FULL_(local)_MYBACKUP_20080701_203440.sqb".

  Every backup file has the date and time appended to it.

  I would like to be able to run a T-SQL command that will find the most current full backup in the directory. Currently I need to change the file name every time I need to restore. My goal is to setup a SQL agent job that will restore the backup in test and dev without any changes to the restore script. Any ideas or ways to do this are appreciated.

  Thanks

• MANU-J.

  SSC-Dedicated

  Points: 31126

  More actions

  July 3, 2008 at 2:37 pm

  #838142

  Try querying the msdb.dbo.backupset table and take the latest entry for the database that you want to be restored.

  Manu