asked
copy backup file
Hi friends, I need to copy 2 backup files for 2 databases from 1 server to
another.It can be powershell, xp_cmdshell , but i need to do this in a sql job. Source : Z:\MSSQL\BACKUP\sqlcluster$Azure_AG1\DBName\Full\sqlcluster$AZURE_AG1_DBName_FULL_20180302_210001.bak I will have 3 files in the location, but I need the latest file . Destination : \\prod-sql01\e$\MSSQL\Backup\DBName\Full\ Can anyone give me some sytax please. I tried with powershell but it give me error, looks like it doesnt' like $
I expect the error you were getting is because you need to escape the $ so that it sees it in the string and not as a variable, you can do this by using ` to escape it.
I found this on a different site and looks like it would work $dir = "C:\test_code" $latest = Get-ChildItem -Path $dir | Sort-Object LastAccessTime -Descending | Select-Object -First 1 $latest.name
Something like this should work for you... $SourcePath = 'Z:\MSSQL\BACKUP\sqlcluster$Azure_AG1\DBName\' $DestPath = '\\prod-sql01\e$\MSSQL\Backup\DBName\Full' $Databases = 'DBName1','DBName2' foreach ($db in $Databases) { $file = Get-ChildItem $SourcePath -Filter "*.bak" | Where-Object {$_.BaseName -match "*$db*"} | Sort-Object LastAccessTime -Descending | Select-Object -First 1 Start-BitsTransfer -Source $file.FullPath -Destination "$DestPath\$($file.BaseName)" }
...or it could be something about the name of your database...
17 People are following this question.
