johnojohno
asked on
MS SQL Restore to a different Server with Diffs and different File Names
Hi Experts,
I receive diff file on a daily bases and the challenge I have is the file names are different each time I get a diff backup but only the date.
I'm attemping to the get the following date format for my script 16042014 - ddmmyyyy but I seem to be getting 2014-04-16.
set @datestring = convert(NVARCHAR(112),getD ate(),23)
I receive diff file on a daily bases and the challenge I have is the file names are different each time I get a diff backup but only the date.
I'm attemping to the get the following date format for my script 16042014 - ddmmyyyy but I seem to be getting 2014-04-16.
set @datestring = convert(NVARCHAR(112),getD
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
set @datestring = replace(convert(varchar(10