Sage Evolution comes with SQL Express Editions but SQL Server Express editions do not offer a way to schedule either jobs or maintenance plans because the SQL Server Agent component is not included in these editions. Therefore, you have to take a different approach to back up your databases when you use these editions.
This article describes how to use a Transact-SQL script together with Windows Task Scheduler to automate backups of SQL Server Express databases on a scheduled basis.
If you are running MS SQL Standard or Enterprise Editions see Scheduling Backup with SQL Server 2012 Standard Editions
Download the script from the link below
[wpdm_package id=770 template=”link-template-default-wdc”]
Extract the files to your local root folder C:/
Open the Backup2.txt and edit the database instance name
Save the file name as Backup2.cmd
Go to Start…All Programs….System tools…..Task Scheduler
Click on Import Task
Locate Evolution Backups.xml extracted from the downloaded file
Click other tabs to configure to your taste.
Don’t forget to drop a comment