Home     |     .Net Programming    |     cSharp Home    |     Sql Server Home    |     Javascript / Client Side Development     |     Ajax Programming

Ruby on Rails Development     |     Perl Programming     |     C Programming Language     |     C++ Programming     |     IT Jobs

Python Programming Language     |     Laptop Suggestions?    |     TCL Scripting     |     Fortran Programming     |     Scheme Programming Language


 
 
Cervo Technologies
The Right Source to Outsource

MS Dynamics CRM 3.0

Sql Server Programming

Data Transfer


Hi,

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

On 5 Jun, 18:58, Shyam <S@discussions.microsoft.com> wrote:

> Hi,

> 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
--

-----------------------------------------------Reply-----------------------------------------------

Hi David,

Nope,the activity is not related to Disaster Recovery. This is for normal
operations.

Thanks.

Add to del.icio.us | Digg this | Stumble it | Powered by Megasolutions Inc