Restore Gene Version 6 - User Guide

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

  • Great article on this. Thank you.

  • Thanks, pleased you like it, cheers

  • 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!

  • 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

  • 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]

  • 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

  • That would be great thanks.

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

  • 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.

  • 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

  • Thanks Clint

  • 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

  • Thanks I'll give it a try

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

  • 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]

  • Excellent, thanks ??

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

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