|
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 @path
This could be executed as a batch with ISQL.
|
