Post reply

Restore script for split backup files

  • 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

  • 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

  • January 18, 2017 at 8:11 am

    #1923438

    Thanks!
    I've sent you a PM.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply