X
logo
Bringing your data sources together
21 February 2010

Using Ouvvi to Schedule SQL Database Backup

We have just added a new Step Handler that runs a backup of a SQL Server Database and additionally you can ZIP up the backup image to save on disk space.

Below is a screenshot of the Step configuration and you can see here were using the Token expansion system for the backup filename which makes it easy to create a unique filename.

image

Tokens

This is a list of the static token values that we have added to Ouvvi

    INSTANCEID
    PROJECTID
    DAY
    MONTH
    YEAR
    FILEDATE
    DATE
    FILETIME
    TIME
    HOUR
    MIN
    SEC
    MACHINE
    USERNAME
    DOMAIN
    APPPATH
    PERSONAL
    SYSTEM
    LOCALAPPLICATIONDATA
    APPLICATIONDATA
    COMMONAPPLICATIONDATA
    PROGRAMFILES
    TEMP
    NEWGUID