Restore Gene Version 6 - User Guide

  • Paul Brewer

    SSCrazy

    Points: 2858

    Comments posted to this topic are about the item Restore Gene Version 6 - User Guide

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    Great article on this. Thank you.

  • Paul Brewer

    SSCrazy

    Points: 2858

    Thanks, pleased you like it, cheers

  • Clint-525719

    SSCrazy

    Points: 2924

    Wow. I wish I had found this about 3 weeks ago. I wrote my own procedure to create DB restore scripts based on our DR needs. However, yours has waaaay more functionality, so I'll be testing it on our systems and probably switch to it.

    I have two questions:

    1) My script may do a couple things that this does not - first thing that comes to mind is that I can pass in a list of DB names in a table variable, and it will only produce scripts for those DBs, and in the listed order. There may be a couple other things too. Would you like me to share the code so you can incorporate it?

    2) Do you know of any scripts that exist to automate the backup/restore of encryption keys and certificates? I'll be building my own shortly if I can't find something.

    Thanks a ton!

  • Paul Brewer

    SSCrazy

    Points: 2858

    Hi,

    Restore Gene accepts a comma separated list of database names but it processes them in alphabetical order, not by ordinal position. That's the stored procedure only, the PowerShell script only processes one database at a time although multiple instances of it can run concurrently once for each database.

    I'm not sure about key backup utilities for SQL Server, sorry. If you do write one I would be interested in seeing it.

    Thanks for the feedback, cheers

    Paul

  • Carolyn Richardson

    SSCrazy Eights

    Points: 8353

    Great script the only change I needed was to put an addition to the where clauses to ensure I did not have a problem with the script when I have mirrored backups, as it was giving me 2 lines for each restore statement both with different server names.

    Facts are stubborn things, but statistics are more pliable - Mark Twain
    Carolyn
    SQLServerSpecialists[/url]

  • Paul Brewer

    SSCrazy

    Points: 2858

    Thanks Carolyn ,

    I honestly thought every possible issue had been handled in the script but never considered the possibility of mirrored backups. It's obvious now you mention it, will get a fix in.

    Best wishes

    Paul

  • Carolyn Richardson

    SSCrazy Eights

    Points: 8353

    That would be great thanks.

    Facts are stubborn things, but statistics are more pliable - Mark Twain
    Carolyn
    SQLServerSpecialists[/url]

  • Clint-525719

    SSCrazy

    Points: 2924

    Paul, I missed the comma-separated list functionality. That also accomplishes what I needed. Thanks for clarifying that.

    I'll let you know once I get the key/cert script done.

  • Paul Brewer

    SSCrazy

    Points: 2858

    Hi Carolyn,

    The fix for mirrored backups is in Version 6.44 here - https://paulbrewer.wordpress.com/sp_restoregene/[/url], also submitted an update to SQL Server Central.

    There's also a fix in the script for an issue that occurred when there were multiple transaction log files, in conjunction with the With Move parameters.

    Regards

    Paul

  • Paul Brewer

    SSCrazy

    Points: 2858

    Thanks Clint

  • Paul Brewer

    SSCrazy

    Points: 2858

    Hi Carolyn,

    A fix for the mirrored backup issue you found is in version 6.44 which SQl Server Central have attached to the article. Please let me know if it doesn't fix the problem, it should be fine now.

    Thanks

    Paul

  • Carolyn Richardson

    SSCrazy Eights

    Points: 8353

    Thanks I'll give it a try

    Facts are stubborn things, but statistics are more pliable - Mark Twain
    Carolyn
    SQLServerSpecialists[/url]

  • Carolyn Richardson

    SSCrazy Eights

    Points: 8353

    The fix for mirror backup works as expected, I tested it out on a few servers. Thanks for the great script.

    Facts are stubborn things, but statistics are more pliable - Mark Twain
    Carolyn
    SQLServerSpecialists[/url]

  • Paul Brewer

    SSCrazy

    Points: 2858

    Excellent, thanks ??

Viewing 15 posts - 1 through 15 (of 15 total)

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