• If you want everything (data, types, users, security settings, etc.), I found the best way to do it is to take a full backup of the source database and then restore it as a different name. This also allows you to move the backup file from one server to another (for example, a test server) and restore it there. Just another option to consider depending on the situation.