I need to transfer the database (as a whole) to another server, to make a duplicate database to setup another test environment.
I have two choices:
- Make a full backup at source server/restore at destination server;
- Detach at source server/attach at destination server.
What are the pros and cons of the two solutions according to my requirements?
I am using SQL Server 2008 Enterprise.