asked on

Have backup of some set of tables and put in another DB daily

Hi Experts,

In my database I've set of configuration related tables. I would like to take back up of those tables on daily basis and put in another database. I would like to automate this process.

How to achieve this? Please do assist.

ASKER CERTIFIED SOLUTION

Surendra Nath

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Easwaran Paramasivam

ASKER

cool. I would like to automate the copying the table data on daily basis. How to achieve this? Please suggest.

Surendra Nath

which procedure you want to choose

for procedure 1, you can simply configure a sql server agent job and schedule it for at a time.
for procedure 2, you can create backup SSIS DTS package and then configure the package in the server agent join and schdule it for at a time.

SOLUTION

Scott Pletcher

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Easwaran Paramasivam

ASKER

I've requested that this question be closed as follows:

Accepted answer: 400 points for Neo_jarvis's comment #a39733506
Assisted answer: 0 points for EaswaranP's comment #a39733526
Assisted answer: 100 points for ScottPletcher's comment #a39736908

for the following reason:

Thanks.

Surendra Nath

If the user closes this question and it is removed from the database, it may end up as non-informational for other users....
Please think on these lines, tommorow some guy may want to see this information and learn from it....

SO, I suggest the question to be kept and the answers accepted properly

Easwaran Paramasivam

ASKER

Thanks.