Skip to posts
  • Publications
  • Code Library
  • Events
  • Presentations
  • Who Am I?
  • Copyright

Wayne Sheffield

My blog about SQL Server
  • Home
  • Publications
  • Code Library
  • Events
  • Presentations
  • Who Am I?
  • Copyright
  • Latest Posts
  • Latest Comments


MCM


MVP

(2017-2022)

Top 50 SQL blog 2018

Recent Posts

  • Availability Group issues fixed with Alerts
  • Using Google Chrome with SSRS
  • Speakers wanted for the Richmond (VA) SQL Server Users Group – 2020
  • T-SQL Tuesday #120 – Recap
  • T-SQL Tuesday #120 – What were you thinking? – Invitation

Top Posts

  • T-SQL Tuesday #48 - My take on the cloud
  • Service Packs and Updates - Tables and Download links
  • T-SQL Tuesday #36 - Community
  • Invitation for T-SQL Tuesday #39 - Can you shell what the PoSH is Cooking?
  • Identifying a row's physical location
  • T-SQL Tuesday #23 - Joins
  • Automating DBCC Page
  • Availability Group issues fixed with Alerts

Archives

Categories

Tags

2020 absolute values (ABS()) Advanced Certifications analytic functions assign sequential number automation Availability Group Back To Basics case-sensitive CLR String Security clustered index common table expression Data Movement deadlock analysis Denali Double-Hop efficiency extracting data from strings Failover Functions Google Chrome import file index analysis myth order by Performance physical tally table Quirky Update Scalar UDF Inlining split string splitting strings SQL SQL 2019 SQL Server SSMS SSMS Tips SSRS String Splitter T-SQL Tuesday tally table Trusted Assembly TSQL Tuesday virtual tally table Why do you do what you do? wrapup

Blogroll

  • Maria Zakourdaev
  • Paul White
  • Benjamin Nevarez
  • Louis Davidson
  • Adam Machanic
  • Paul Randal
  • Kevin Kline
  • Andy Leonard
  • Robert Pearl
  • Jorge Segarra
  • Kendra Little
  • Steve Jones
  • Phil Factor
  • Lynn Pettis
  • Grant Fritchey

Move-Files

PowerShell
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
<#
.DESCRIPTION
Copy the cluster xel files to another directory so that they aren't aged off too soon.
 
.PARAMETER $SourcePath
Location of the source files. ie: C:\temp\source
 
.PARAMETER $DestinationPath
Location where the source files should be moved to. ie: C:\temp\destination
 
.PARAMETER $FileNamePattern
A description of what the file name looks like. Accepts wildcards. ie: "*.xel".
 
.PARAMETER $DaysToRetainDestinationFiles
The number of days that the files should stay in the destination folder before being deleted.
 
.NOTES
Author: Wayne Sheffield
Date: 2016-12-06
Script's Home:
*******************************************************************************
                               MODIFICATION LOG
*******************************************************************************
2016-12-06 WGS Initial Creation.
*******************************************************************************
#>
 
param
(
[string] $SourcePath,
[string] $DestinationPath,
[string] $FileNamePattern,
[int] $DaysToRetainDestinationFiles
 
)
# Ignore errors when file is locked by another process
# $ErrorActionPreference = "SilentlyContinue"
 
# Get the files to copy
$SourceFiles = Get-ChildItem $SourcePath | Where-Object {$_.Name -like $FileNamePattern};
 
# If the file is not in the destination folder, and it's size is > 0, then move it to the destination folder.
# This will prevent trying to copy the currently open file.
ForEach($File in $SourceFiles) {
    If (-Not (Test-Path ($File.FullName.Replace($SourcePath, $DestinationPath))) -and ($File.Length -gt 0)) {
        Move-Item $File.FullName -Destination $DestinationPath -Force
    }
}
 
# Remove files in the Destination Path over 5 days old.
Get-ChildItem -Path $DestinationPath | Where-Object {$_.CreationTime -lt (Get-Date).AddDays(-$DaysToRetainDestinationFiles)} | Remove-Item -Force;

 

Share this:

  • Share on X (Opens in new window) X
  • Share on LinkedIn (Opens in new window) LinkedIn
  • Email a link to a friend (Opens in new window) Email
  • Print (Opens in new window) Print
  • More
  • Share on Facebook (Opens in new window) Facebook
  • Share on Pinterest (Opens in new window) Pinterest
  • Share on Reddit (Opens in new window) Reddit

Like this:

Like Loading…
Powered by WordPress Web Design by SRS Solutions © 2026 Wayne Sheffield Design by SRS Solutions
Manage Cookie Consent
To provide the best experiences, we use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us to process data such as browsing behavior or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions.
Functional Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes. The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
  • Manage options
  • Manage services
  • Manage {vendor_count} vendors
  • Read more about these purposes
View preferences
  • {title}
  • {title}
  • {title}
%d