<OakRogbak_erPine@yahoo.com> wrote in message
news:13fdc9b4.0310080623.7784f5b2@posting.google.c om...
> My company is considering purchasing MS SQL Server to run an
> application on (SASIxp). I am mainly familiar with Oracle, so I was
> wondering how long it would take to copy a database. Basically we have
> database A and each night we want to replace database B with the
> contents of A. How long would this take say if we had a 10GB database
> or a 20GB database.
>

Well, your maximum speed is limited by hardware. And depending on how you
move things, you may get close to that speed.


> What would be the technique to do this nightly, the Copy Database
> Wizard, Snapshot Replication, Attach & Detach...? We need to automate
> this process, and the source database can be made unavailable when
> this happens.

Probably the easiest way given you can suffer from downtime is to do a
detach, copy, attach.

In that case you're pretty much limited to hardware speeds.


>
> Thanks,
> Roger