Hi,

I need a way to automaticly backup and delete part of a database. The database is continously logging values from an HMI program. In order to not allow the database to grow to large, I want to each month take backup of and delete the data collected the previous month. That way data for the current month will be available to be viewed in the HMI program. Is there a way to do this through an SQL query? The timing is no problem as this can be done with logic in the HMI application. It is the query to tell the database to create a backup of and delete the data for the prvious month i need help with.