In my project, every one taking the Adhoc backup on different folder which was created an issue to cleanup backup files to find and cleanup. We proposed a standard format as F:\AdhocBackup\Until\YYYYMMDD
Eg: F:\AdhocBackup\Until\200250823
The two scripts below can to achieve the above requirements
Note: Add the backup script as per your standard while taking the backup
--Powershell script
--- Backup folder future 7 days
# Get date after 7 days in yyyyMMdd format
$futureDate = (Get-Date).AddDays(7).ToString("yyyyMMdd")
# Build folder path
$folderPath = "D:AdhochBackupsUntil$futureDate"
# Print to verify
Write-Output "Creating folder: $folderPath"
# Create the folder if it doesn't exist
if (-not (Test-Path $folderPath)) {
New-Item -ItemType Directory -Path $folderPath | Out-Null
Write-Output "Folder created successfully."
}
else {
Write-Output "Folder already exists."
}
------Cleanup folder
$today = Get-Date -Format "yyyyMMdd"
$path = "D:AdhochBackupsUntil$today"
if (Test-Path $path) {
Remove-Item -Path $path -Recurse -Force
}
--- Backup folder future 7 days
# Get date after 7 days in yyyyMMdd format
$futureDate = (Get-Date).AddDays(7).ToString("yyyyMMdd")
# Build folder path
$folderPath = "D:AdhochBackupsUntil$futureDate"
# Print to verify
Write-Output "Creating folder: $folderPath"
# Create the folder if it doesn't exist
if (-not (Test-Path $folderPath)) {
New-Item -ItemType Directory -Path $folderPath | Out-Null
Write-Output "Folder created successfully."
}
else {
Write-Output "Folder already exists."
}
------Cleanup folder
$today = Get-Date -Format "yyyyMMdd"
$path = "D:AdhochBackupsUntil$today"
if (Test-Path $path) {
Remove-Item -Path $path -Recurse -Force
} 
This script will help to find orphan users on all databases and will remove them.
2025-05-20
196 reads
2025-05-06
460 reads
This script runs a SQL server Health check for services, databases, Always On, replication, CDC job status.
2025-05-05
451 reads
It depends. The mantra of many DBAs and others in IT. Steve Jones reminds us why it applies.
2020-06-23 (first published: 2009-03-25)
587 reads
Encryption in SQL Server is difficult to implement and manage, but it is being required more and more often. However understanding what encryption means is as important as being able to manage and implement it. Michael Coles brings us part 2 in his series on explaining the mysteries behind cryptography.
2005-08-17
11,116 reads