Hi,

Just a quick note to advice getting the latest version of the stored procedure and PowerShell script.

Click here for the most current version of the ps_RestoreGene script. [/url]

Click here for the most recent version of the sp_RestoreGene stored procedure.[/url]

There are a few issues addressed in version 3.6 including:

1. The Write-Host PoSh command was not working properly in SQL Agent jobs, a new $ConsoleFeedback PoSh parameter can be set to 0 to suppress Write-Host.

2. There were issues when the database name contained a space or a full stop

3. Query timeout issues during long running restores

4. The PoSh 'Throw' command used when there are no new log backups has been changed to 'Exit'. IE, in Log Shipping mode when there are no new backups then exit.

5. Include Device Type 7 backups in msdb to support Amazon Web Service network drives.

These were all suggestions from people using it, most of the fixes were actually supplied by them.

Best wishes

Paul