FYI

sp_flush_CT_internal_table_on_demand [ @TableToClean= ] 'TableName'

Thank you for the feedback.

I steped away from tsql scripting for this purpose.

I use a powershell script/module to assemble and restore databases from whatever sqlserver source to a given sql server target.

You can find...

I chocked and was shocked seeing this:

import-module sqlserver

Get-SqlPort -sqlserver myserver\myinstance

result

Get-SqlPort : SQLDMO is not installed.

At line:1 char:1

SQLDMO ????????

Oh, wait, maybe that's the one coming from the "old" SQLPSx installation

Thank you for the feedback.

Glad to read to got it fixed.

first make a tail log backup

then you can use 'restore filegroup ' starting from your latest full backup

then restore diff backup if available

then restore logs as needed ending with...

or even better, submit it as an SSC article !

Marketing only highlights the fancy stuff !

Users want it to work

DBA want...

is your name column Nullable and are there rows where it is null ?

ref: Something About Nothing: NULL By Kathi Kellenberger[/url]

ref: NULL Versus NULL? By Michael Coles[/url]

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...