Backup using SQL Query and Task Scheduler

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

Step 1

Download the script from the link below

[wpdm_package id=770 template=”link-template-default-wdc”]

 

backup view

Extract the files to your local root folder C:/ 

Open the Backup2.txt and edit the database instance name

backup2

Save the file name as Backup2.cmd

backup 3

 Step 2

Go to Start…All Programs….System tools…..Task Scheduler

backup 4

backup5

Click on Import Task

Locate Evolution Backups.xml extracted from the downloaded file

backup6

 

Click Open

backup7

 

Click other tabs to configure to your taste.

Don’t forget to drop a comment

One thought on “Backup using SQL Query and Task Scheduler

Leave a Reply

Your email address will not be published. Required fields are marked *