> > I'm looking for methods in SQL Server 2000 to transfer the DB from Server 1
> > to Server 2 which should be done on daily basis. But i would consider doing
> > it in the fastest way. As far as i know can be done using Replication
> > (consumes more resources) so i would not prefer, robocopy, xcopy via terminal
> > server,FTP, Mapped drive, or 3rd party tools like X-Backup,etc.

> > But i'm not 100% sure to choose the best option and which would complete in
> > the shortest span of time. I know there are lots DBA's who would have come
> > across such scenarios. Any comments/suggestions would be grateful.

> > Thanks,
> > Shyam

> If the purpose is for disaster recovery then you can consider log
> shipping.

> --
> David Portas, SQL Server MVP

> Whenever possible please post enough code to reproduce your problem.
> Including CREATE TABLE and INSERT statements usually helps.
> State what version of SQL Server you are using and specify the content
> of any error messages.

> SQL Server Books Online:
> http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
> --