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.

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.

Thanks,
Roger