About twice a day for a few weeks I need to back up 2-3 tables, maybe more.
1 table of 45000 and two of 18000 records.
It needs to be automated with the facility to run manually,
I could write the data to a CSV file or even to a MySql database.
But I am sure a Stored Procedure run from a SQL Job would be more efficient.
I can create the job in Enterprise Manager but cannot write the stored procedure for this task.
Any help or examples would be appreciated