TEC-3 – Schedule a backup of the Ecaldima Database

Version(s)

From ECALDIMA 2.0

Description

Schedule a backup of the Ecaldima database using SQL and the Ecaldima Scheduler

Use

SQL Server Express does not have the SQL Server agent to schedule backups. A backup can be scheduled from the query scheduler. In the menu Parameters / Tools / Scheduled queries, create a new query and copy the query:

-- Copy the script under this line
Declare @FileName nvarchar(500)
Declare @Date nvarchar(50)
Declare @TaskName nvarchar(100)
Declare @DatabaseName nvarchar(50)
SELECT @Date = CONVERT(nvarchar(50), getdate(),112)
SELECT @FileName = 'C:\Backup Ecaldima' + @Date + '.bak' 
SELECT @DatabaseName = 'ECALDIMA' 
SELECT @TaskName = @DatabaseName + N'-Full ' + @Date

BACKUP DATABASE @DatabaseName TO DISK = @FileName WITH NOFORMAT, INIT, NAME = @TaskName, SKIP, NOREWIND, NOUNLOAD, STATS = 10

--Copy to this line

Change the FileName and DatabaseName variable to suit your installation