Community
Showing results for 
Search instead for 
Do you mean 
Reply

Scheduler_File.xml file and script on 2011 V13

Tuned Listener
Posts: 57
Country: France

Scheduler_File.xml file and script on 2011 V13

Hi,

 

I tried to rename the Scheduler_File.xml by Scheduler_File.old to rebuilt...not working.

So i décided to backup by script.

Could you give me the script:BUT for V13 SQL8

 

REM - Change the SET Parameters to suit your system
SET ACTSourceFolder="C:\Act\Database"
SET ACTDestinationFolder="D:\Backups\Act\Database"
SET XcopyOptions=/M /E /C /H /O /Y /I
REM
REM - Stop the ACT Service
NET STOP SQLAGENT$ACT7
NET STOP MSSQL$ACT7
REM
REM - Copy the files
XCOPY %ACTSourceFolder% %ACTDestinationFolder% %XcopyOptions%
REM
REM - Restart the ACT Service
NET START MSSQL$ACT7
NET START SQLAGENT$ACT7
END

 

Thanks