I am using SQL Server 2008 Enterprise. I need to transfer the database (as a whole) to another server (to make a duplicate database to set up another test environment).
I have two choices, (1) making a full backup at source server/restore at destination server; (2) making detach at source server/attach at destination server.
Any pros and cons compared of the two solutions according to my requirements?
thanks in advance, George