Post reply

Restore Gene Version 6 - User Guide

  • September 12, 2016 at 11:01 pm

    #329788

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

  • September 13, 2016 at 6:29 am

    #1900513

    Great article on this. Thank you.

  • September 13, 2016 at 6:30 am

    #1900514

    Thanks, pleased you like it, cheers

  • September 13, 2016 at 3:25 pm

    #1900683

    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!

  • September 14, 2016 at 12:58 am

    #1900725

    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

  • September 14, 2016 at 8:02 am

    #1900834

    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]

  • September 14, 2016 at 8:31 am

    #1900840

    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

  • September 14, 2016 at 1:00 pm

    #1900940

    That would be great thanks.

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

  • September 14, 2016 at 1:55 pm

    #1900956

    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.

  • September 14, 2016 at 5:10 pm

    #1900988

    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

  • September 14, 2016 at 5:11 pm

    #1900989

    Thanks Clint

  • September 19, 2016 at 12:52 am

    #1901557

    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

  • September 22, 2016 at 9:35 am

    #1902514

    Thanks I'll give it a try

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

  • September 22, 2016 at 9:45 am

    #1902517

    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]

  • September 22, 2016 at 10:04 am

    #1902529

    Excellent, thanks ??

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

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