I'm here today for the Python session, should be back on Sat too

You can't restore (or attach database files) from a more recent version of SQL Server to an older version.
Most likely you'll need to script/dump the schema & data for...

Need to put some parts on new lines:

$isodate=Get-Date -format s

August 16, 2017 at 12:30 pm

#1955555

Thanks.
Your URI is incorrectly formatted - what's the path of the remote file?
Assuming it's at *ftp*\DIFF\*file* I think your uri parameter should be:

$uri = New-Object...

Posting the error you get would be helpful.

From what's in your other post, I'd reiterate what I said there - sort your indexing out first and see how things change. Particularly the heaps.

Things to check:

Below 50ms for reads is generally considered good in SQL (I'm assuming you're referring to the sec/Read counter). So not really seeing a problem there.

"Obviously this results in...

What I like is I can run these commands unedited on my machine... !

Regarding installing CU2, culmative updates are relevant to the service pack they're for, so you won't be able to install CU2 for the RTM release on top of SP1.
Presumably...