Hi all I am trying to create a batch file that will create a folder of todays date, then backup the db file to that folder, something along the lines of..
Appreciate any guidance on this Thanks C |
IMHO that looks ok, but you might want to add the eng={enginename} parameter to the connection string. create variable @path varchar(127); set @path= String('C:\Backup\',dateformat(today(),'mm_dd_yyyy')); backup database directory @pathThis could be executed as a batch with ISQL. |