Reguarly back up tables

code green

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

Nov 4 '08 #1

ck9663

Create a stored proc that will BCP out your table to a CSV. Just build your query dynamically. Of course, you have to check if the file is existing and all those.

Then create a scheduled job calling your SP.

-- CK

Nov 5 '08 #2