<div>
it is possible with a help of <a href="https://msdn.microsoft.com/en-us/library/ms175046.aspx" rel="ugc nofollow">xp_cmdshell</a> 
You will need to execute DOS commands. E.g. to check if file exists you can execute this command: 

<pre><code class="code-1 nolinks" id="code-20-42052162-1">exec msdb..xp_cmdshell 'if exist c:\test.txt echo exists!'
</code></pre>
If you want to copy file use: 

<pre><code class="code-1 nolinks" id="code-20-42052162-2">exec msdb..xp_cmdshell 'copy c:\test.txt c:\test1.txt'
</code></pre>
Note: the folders need to be related to the SQL Server, not the client where you execute the SQL queries
</div>

<div>
I would use Powershell to accomplish this. Here is a link to get the snap-ins installed <a href="https://technet.microsoft.com/en-us/library/cc281947(v=sql.105).aspx" rel="ugc">https://technet.microsoft.com/en-us/library/cc281947(v=sql.105).aspx</a> 
From there you can use the Invoke-SQLCMD to query and loop through the records to run a test-path if the fullpath exist and if so do something like remove-item. 
 

<pre><code class="code-10 nolinks" id="code-20-42052177-1">#
# Add the SQL Server Provider.
#

$ErrorActionPreference = &quot;Stop&quot;

$sqlpsreg=&quot;HKLM:\SOFTWARE\Microsoft\PowerShell\1\ShellIds\Microsoft.SqlServer.Management.PowerShell.sqlps&quot;

if (Get-ChildItem $sqlpsreg -ErrorAction &quot;SilentlyContinue&quot;)
{
 throw &quot;SQL Server Provider for Windows PowerShell is not installed.&quot;
}
else
{
 $item = Get-ItemProperty $sqlpsreg
 $sqlpsPath = [System.IO.Path]::GetDirectoryName($item.Path)
}


#
# Set mandatory variables for the SQL Server provider
#
Set-Variable -scope Global -name SqlServerMaximumChildItems -Value 0
Set-Variable -scope Global -name SqlServerConnectionTimeout -Value 30
Set-Variable -scope Global -name SqlServerIncludeSystemObjects -Value $false
Set-Variable -scope Global -name SqlServerMaximumTabCompletion -Value 1000

#
# Load the snapins, type data, format data
#
Push-Location
cd $sqlpsPath
Add-PSSnapin SqlServerCmdletSnapin100
Add-PSSnapin SqlServerProviderSnapin100
Update-TypeData -PrependPath SQLProvider.Types.ps1xml 
update-FormatData -prependpath SQLProvider.Format.ps1xml 
Pop-Location


# Gather Table for DB

Set-Location SQLSERVER:\SQL\xxxprolaw\prolaw\databases\prolaw
#gets the query results and stores in an array 
$Records = Invoke-Sqlcmd -Query &quot;SELECT * from CreditValueLevels&quot; 
#for each record Test if the path exists and then do something
Foreach ($record in $records)
{
 If (Test-Path -Path $record.Fullname)
 {
 Remove-item $Record.Fullname -Recurse -Force
 }
}
</code></pre>
</div>

<div>
Thanks, Vitor. &nbsp;It looks like the maintenance plan will take care of deleting older versions of database backups for me. &nbsp;I was looking for a way to do this manually but think doing it in the maintenance plan is the way to go.
</div>

<div>
<div class="content wysiwyg-content">
I'm working on a procedure to determine whether a file exists on the path referenced in a field of my database. 
 
In some instances, I will need to be able to copy this file to another location on my server and then delete the original once I've confirmed that the copy operation was successful. 
 
how can I accomplish this with T-SQL in Sql Server 2008 R2
</div>
</div>

I'm working on a procedure to determine whether a file exists on the path referenced in a field of my database.

In some instances, I will need to be able to copy this file to another location on my server and then delete the original once I've confirmed that the copy operation was successful.

how can I accomplish this with T-SQL in Sql Server 2008 R2

Using T-SQL (SQL Server 2008 R2) to determine whether file exist on server and delete it

T-SQL

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.