Need to help to transefer data from 1 server to another

[sugu]

Hi

I have 2 servers of which one is a backup n both running sql server standard edition.

I need to send the tables and database in server 1 to be transfered into the server 2 every night automatically.

Is there a way to do it?

Thanks in advance!

su

 

[jbenson001]

Use DTS packages. They can be scheduled.

Jim

 

[sugu]

sorry how do i go about doin the dabase transfer with DTS? I'm very new to sql server.


Thanks!

su

 

[fredericofonseca]

Read BooksOnline (supplied with your copy of SQL Server, or available on microsoft.com) for all information you need.

If you have Enterprise Manager you select option Data Transformation Services, and go from there.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[SQLDenis]

You could also set up replication for the tables

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[icemel]

or do a nightly backup on server 1 and restore on server 2

 

[sugu]

I'm looking for a automation for the replication/backup to take place.

su

 

[fredericofonseca]

do any of the ones that were mentioned before.
If a DTS package you will then need to schedulle it as a job so you have automation.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com