The disk io associated with this script is almost exclusively writes. It clears down data at the start of each call, inserts a starting dataset then generates new patterns. This...

That's a really good idea, I should have considered cost too instead of focusing completely on the performance perspective. Factoring in cost would added a dimension the articles lacking, trying...

You might need this installed on the server you are running powershell from - http://www.microsoft.com/en-gb/download/details.aspx?id=11829

Regards

Are there any login failures in the SQL server error log on the primary?

Is the tcp-ip protocol enabled on the primary?

Regards

Yes, to start the process off you supply '1' for the initialize parameter, it then uses the full backup and all logs.

Subsequently, later after more log backups were taken, you...

After putting the database in full recovery, did you take a full and a log backup?

That's good news, pleased you got to the bottom of it. I'll add an error trap to the posh script on the next release. To be honest it wasn't a...

It should do, I'm not sure to be honest and need to retest. The most recent version was developed on Windows server 2012, PS V3. The error might be a...

Hi,

There is some documentation here - https://paulbrewer.wordpress.com/2014/08/15/restore-gene-version-3-free-public-framework-technical-article/

Which version of powershell are you using?

Thanks

Could you try version 4 (the latest) https://paulbrewer.wordpress.com/ps_restoregene/

Thanks

Withmovedatafiles appears twice, also needs to terminate with '\'

Regards

Hi,

I'm not familiar with the Idera backup process to be honest but suspect they use volume shadow copy technology the same as DPM. You'll probably need to use their management...

Thanks Kiran,

This is the latest version of the procedure - https://paulbrewer.wordpress.com/sp_restoregene/

It includes support for backup forking and various other mod's.

Best wishes

Paul

This article has 3 possible solutions, 1 that uses geometry, 1 that uses set based queries and 1 that uses Hekaton in-memory tables and procedures. It also has a nice...

Hi,

If you are interested in how quick Hekaton is, run the SQLServer2014 setup script attached to the article then the script below in 1 or more Query Analyser sessions. It...