The main point is that after a shrink operation ( other than truncate only ), you need to perform FULL maintenance on your database !

This may cause your LDF...

SQL2014 ( sp1 CU4 )

I've had issues using simple commands like using this in-line

$('{0} - {1}' -f $env:computername, $CurrentDtyyyyMMdd_HHmm )

changing the jobstep to CMDexec and launching a powershell script...

When will SQLAgent finally upgrade its Powershell subsystems Version ( currently restricted to V2 ) ? syntax has changed and enhanced a lot since V2.

I wouldn't count on it.

btw. you can start xEvents to capture deprecated on your current SQL2008R2 instance and preparing for the fix.

ref Track Deprecated Features with Extended-Events[/url] .

...

Andy Warren (12/3/2015)

---

Deep breath Johan! I'm with you on checksum, I just didn't use it for my tiny test backup when I was scripting. I'm a fan of checksum myself....

dndaughtery (12/3/2015)

---

Well, that's not the exact query I'm working on. Scaled it down quite a bit. My query has 80 columns with several case statements etc that returns 1 million...

...It means you have to check the backup before you set the options for the restore. For my revised code & test above you can infer that my backup did...

did you try this ?

Select PrimeKey, Col_A, Col_B, Col_C, Col_D, Col_A_B

from ( Select PrimeKey, A.Col_A, A.Col_B, A.Col_C, A.Col_D, B.Col_A AS Col_A_B,

RANK() Over(Partition BY A.Col_A, A.Col_B, A.Col_C, A.Col_D, order by...

You can do that using e.g. a scheduled task providing that wanted windows account as execution account of that task.

and then have that task execute the wanted sqlcmd using the...

Great feedback, guys ! :w00t:

Thanks.

to use Windows authentication use the parameter -E in stead of the -U and -pwd

ref:https://msdn.microsoft.com/en-us/library/ms162773.aspx

first of all, you only have to install the most recent CU.

First install that CU at the non-active node.

the you will have downtime ! for failing over the SQLinstance from...

Database mirroring in use ?

With regards to Error 18456 I always use Aaron Bertrand's article: Troubleshooting Error 18456

tt-615680 (9/25/2015)

---

Thank you for your help! I’ve tried to run the scrip but unfortatly I get the following error message, I have changed the location name where the transactional log...

Set-location "c:\myfolder\SQLBackups"

# List all files and order by LastWriteTime descending

get-childitem -Filter '*.BAK' | Select FullName, LastWriteTime | sort LastWriteTime -Descending | ft -AutoSize

# only the most recent file

$Bakfile =...