Moving Databases to Different Servers

Sometimes you want to have the same database on more than one server. Perhaps you want to take a copy of a production server to create a test database, or move a database to a client site. In addition, you may need to maintain a warm standby server. You can do this in several ways:

• Using BACKUP and RESTORE

• Using Data Transformation Services (DTS)

• Using sp_detach_db and sp_attach_db