Would there be any advantage(speed) to strip my backup even though my drive that I'm backing up to is part of a San

where it's not on it own storage location.

I...

It just a native SQL backup process.

Thanks for ALL the info.

Thanks for info,  have output in .txt file now. What syntax for the P/S script to strip a distinct list of folders?

Thx.

Thanks again!!

Thanks,

Is it a problem that for each script it pops open a Window to execute?

Do you see any downside of using something like this embedding in original script?

$scriptsList = 
@(
    'C:\Users\WP\Desktop\Scripts\1.ps1'
    'C:\Users\WP\Desktop\Scripts\2.ps1'
   ...

Are you suggesting

Depending upon how much data you are saving, it may be faster/easier to select what you want to keep into a new table. Drop the PK, FK and...

Thx.

Thanks was trying to find it...

Was there a way to log the numbers of deletes as I go.

Thx.

Works great, any way to dump the field data it finds to a generic error_log table, and be able to scan multiple tables at once.

Thx.

I also don't think it's checking for an Empty value in the fields.

thx.

Thanks that helped me find a solution.

any examples of the dynamic pivot?

yes dynamic pivot...

ContainerID,ItemID,Grosswgt,equipID,Onhold,Scrapped,TEST, and TESTValue for the indiviual test