Home » Blog » Topic » SQL Server most recent backup problem

SQL Server most recent backup problem

Lincoln Burrows ~ Modified: September 10th, 2015 ~ ~ 1 Minute Reading

Home › Forums › SQL Server most recent backup problem

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • September 10, 2015 at 1:01 pm #628 Score: 0
    Lincoln Burrows
    Moderator
    16 pts

    I’m using a simple maintenance plan to take nightly backups of some production databases to a UNC path within our network. I want to create a job that will pick these backups up and restore them on to a test server. Either on demand or on a schedule. I’m keeping seven days backup in the UNC target and I want to be restoring the most recent backup.

    September 11, 2015 at 12:49 pm #636 Score: 0
    Andrew Jackson
    Moderator
    1 pt

    Use the backup history tables in msdb to retrieve the filename and path of the most recent backup.

    September 14, 2015 at 11:48 am #646 Score: 0
    Stephen West
    Moderator
    4 pts

    You can use the date created property from the file system to choose the youngest backup. This was the solution I wanted.

  • Author
    Posts
Viewing 3 posts - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.