By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,856 Members | 2,149 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,856 IT Pros & Developers. It's quick & easy.

Reguarly back up tables

code green
Expert 100+
P: 1,726
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
Share this Question
Share on Google+
1 Reply


ck9663
Expert 2.5K+
P: 2,878
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

Post your reply

Sign in to post your reply or Sign up for a free account.