Restore script for split backup files

• A3Paper

  SSChasing Mays

  Points: 636

  More actions

  January 17, 2017 at 9:34 am

  #334006

  Hi,

  Does anyone have a script handy that'll identify the most recent full backups within a directory using xp_cmdshell, recognise the backup is between multiple files and restore the db?

  Thanks

• BrainDonor

  SSCoach

  Points: 19262

  More actions

  January 18, 2017 at 7:29 am

  #1923425

  A3Paper - Tuesday, January 17, 2017 9:34 AM

  Hi,

  Does anyone have a script handy that'll identify the most recent full backups within a directory using xp_cmdshell, recognise the backup is between multiple files and restore the db?

  Thanks

  I'm busy testing a stored procedure that I'm writing, to restore databases from a specified linked server, change the name and run DBCC against them - to check the backups are good. 
  I haven't finished testing it yet but there should be enough within it for you to pick the appropriate bits out. And it doesn't use xp_cmdshell - it gets the backup details from the history.
  If you're interested them PM me and I'll send you a copy.

  Steve Hall
  Linkedin
  Blog Site

• A3Paper

  SSChasing Mays

  Points: 636

  More actions

  January 18, 2017 at 8:11 am

  #1923438

  Thanks!
  I've sent you a PM.