Forum Discussion

Copper Contributor

Jun 26, 2021

file concatenation

Hi , I am writing a proc to handle backup location for a restore script. can anyone suggest me how to generate complete path using both locations as below and final path name silty different as w...

sql server

olafhelper

Bronze Contributor

Jun 28, 2021

nasdba , do you mean a simple replace?

declare @base nvarchar(400) = N'\\backupserver\sqlbackup'
declare @path nvarchar(400) = N'K:\Backups\localserver\PRD_DW_ABCD\FULL\localserver_PRD_DW_ABCD_FULL_20210621_140002_1.bak'

select replace(@path, N'K:\Backups', @base);