Creating DTS Package to archive database from one sql server to another

Hi...

I am new to database programming.

I need to create a DTS Package which should archive a database fron one sql server to another.

I have no idea that which connection objects and which task objects should be used in order to accomplish this task.

Please help me with this.

Any one of your help is greatly appreciated.

Thank youHi There,

Use "Transfer Databases" task. You can find that under Task menu.

Select appropriate options under each tab. Its pretty straight forward.

Test this DTS first using a test database before implementation.

Good Luck!|||I have moved your question from the Articles section of our site to the Forum.