Normally there are two ways to implement this.
1) Using SQL Executive (need to start the service after a fresh install)
you can setup a DB-Transfer to automatically occur once a night in
the wee hours.
2) Using SQL Enterprise you can setup a mirror to your second machine.
Regards,
Kurt
Our development department is currently testing with SQL 7.0.
We would not recommend you implement on SQL 7.0 right now.
Rudy Komsic wrote:
> Hi,
>
> I was wondering if anyone have proper scripts to do replication on another
> server. I would like to set up a backup server so when one goes down or is
> busy, it will replicate on the other server.
>
> Also Is it really worth it to upgrade to SQL Server 7.0?
>
> For more information about this list, including removal,
> please see http://www.iea-software.com/maillist.html
For more information about this list, including removal,
please see http://www.iea-software.com/maillist.html