Hi Darryl,

The latest version of the script is here - sp_RestoreGene – Paul Brewer (wordpress.com)

You should be able to achieve this restore objective using the @TargetDatabase parameter (to avoid...

Get well soon!

Thanks for the feedback, I’ll update the comments section in the next release with this.

I think the advantage is in situations where nodes have multiple edges. In the article there is a CTE that generates a network hierarchy, each node has three edges to...

Is that how you spell it? I've no idea about chemistry but love some of the R packages their community are developing!

Excellent, thanks ??

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

Thanks Clint

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

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

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

Thanks, pleased you like it, cheers

Newer SAN's have a 'de-duplication' feature intended for these scenarios. You snapshot the drives used by one SQL instance to store files and present them as new drives to another....

Hi,

The latest version is here http://www.sqlservercentral.com/articles/Restore/111917/

Regards

Hi,

Yes, was actually designed to compare physical servers with VM's - https://paulbrewer.wordpress.com/2015/07/19/sql-server-performance-synthetic-transaction-baseline/

Regards