I'm using the below to backup a db from a SQL job. Can someone tell me how to add the current date to the output filename? Preferably in YYYYMMDD format.
Asked
Active
Viewed 25 times
0
-
what syntax are you using to backup your db? – Zeina Sep 19 '19 at 11:00
-
`getdate()` gives you the current date. `convert()` will convert it to the format that you required. it is not that difficult. Give it a try – Squirrel Sep 19 '19 at 11:33
-
Where is "below"? – Wolfgang Kais Sep 19 '19 at 12:13