No login failure messages on primary and I checked TCP IP is enabled on primary as well.

Here's the interesting thing while i tested with Log shipping option set to 1, it is throwing an error:

PS C:\> C:\Automate\TEST\Restore\ps_RestoreGene_v4.0.ps1 -LogShippingInitialize "1"

cmdlet ps_RestoreGene_v4.0.ps1 at command pipeline position...

Adding ----- For server XXX primary it displays below info followed by the message i posted:

Name : LogData

LocalName ...

Yup, that was the first thing i did..

Just curious, for very first run i provided the parameter -LogShippingInitialize "1" as "0"..

Could that be a problem, do i need to...

But Paul,

Actually it ran but its not restoring, it just shows me the above posted message and no restore happens.

What Am i missing now, even i put the database to...

Hey, Paul i was able to figure out what went wrong and ran the script, but after its run no restore happen with below message:

database on primary is in Simple...

Hi Paul,

Any idea what could be going wrong here, Will it not work for V 2.0 PS?

Thanks for the doc, its V2.0

hey paul,

Thanks for the replies, yes i am using the latest version but still same error. May be i am not that good or doing something wrong with Powershell.

Is there...

Sorry my bad, i copied it wrong, made the modifications, replaced withmovedatafiles to withmoveLogfiles and ended with \ for the path but still same error:

Set-Location : A parameter cannot be...

I am getting the below error when trying to execute the Posh

Set-Location : A parameter cannot be found that matches parameter name 'DBName'.

I am using below script on PS v2.0

Automate\TEST\Restore\ps_RestoreGene.ps1...

Hi,

I am taking backups via Idera SQL safe.

Will this work in that case and give the restore commands back in a format that Idera can understand?

Hi I am MCTS in SQL server 2008 and have 1+ Years of Experience on Same.

Kindly let me know for any openings so that i may apply for.

Currently i am...