Try modifying the RedgateRestore function, adding the $SQLCommand.CommandTimeout line below.

$SQLCommand = New-Object system.Data.SqlClient.SqlCommand($SQLQuery, $SQLConnection)

$SQLCommand.CommandTimeout = 10000

$SQLCommand.ExecuteNonQuery() | Out-Null

Setting the CommandTimout value to 10,000 was completely...

If the restore is happening the only thing left is the ChageDBOwner function. Make any modifications there? Try sending $SQLQuery out to a file and check that it's...

Try

$FullPath2 = [Regex]::Replace(a.FullPath, "Q:", "")

No need to read-host. I added that "param ( [switch]$disable )" line so you can add -disable (or not) to the command line when calling your script.

For example, if...

You just missed a couple of small things but they do make a difference.

First -like and -match work differently

Second, in your line $jobs.IsEnabled = $TRUE

$jobs is a collection of the...

If you're still interested in a Powershell method try this.

Add-Type -AssemblyName "Microsoft.SqlServer.Smo, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" -EA Stop

foreach ($server in $(Get-Content -Path serverList.txt)) {

$srvObject = New-Object -TypeName Microsoft.SqlServer.Management.Smo.Server...

Great script Lowell, it’s definitely going in my traveling SQL bag. Thanks.

The Script method of the Mail object doesn't get the SMTP server information and neither does the Script method for the Accounts object. I guess it's just an SMO...

Glad you liked it. Here's what I use for operators.

# Configure the SQL Agent to use dbMail and add operators .

$sqlSrvObject.JobServer.AgentMailType = 'DatabaseMail'

...

Try replacing $ds.Tables[0] | out-gridview with

foreach ($dataRow in $ds.Rows) {

$dataRow ["suid"]

$dataRow ["status"]

$dataRow ["accdate"]

$dataRow ["totcpu"]

...

Just an FYI if you run Get-Help Select-Sting where you see -Pattern <string[]) that [] means -Pattern takes an array. That applies to all items with a <string[]> in...

Try

Select-String -pattern "Found file", "Records IN", "File copied" |

Not sure why your're still getting errors. I'd check those servers manually just to make sure it's not a WMI availability, OS version or permissions issue.

If it fails on the same servers every time it could be an issue with the txt file. I've seen a copy/paste from an outlook email to a txt...

If you have access to Powershell it's a three liner

Add-Type -AssemblyName "Microsoft.SqlServer.Smo, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" -EA Stop

$srvObj = new-object -TypeName Microsoft.SqlServer.Management.Smo.Server -ArgumentList 'YourServerNameHere'

$srvObj.Logins | Where {$_.LoginType -eq 'SQLLogin'} | Select...