Answer D is correct. The fastest way to move a database to another server it to simply take the database offline and transfer the files to the new server. When it is on the new server, you can use the ATTACH method to install the database in the new environment. All-in-all, the process takes only a minimal time over and above the actual file transfer time. Transactional replication does not move the database. For more information, see the following sources:
|