There are multiple reasons why a user may want to make a copy of the database. Sometimes a user wants to copy the database to the same server and sometime wants to copy the database on a different server. The important point is that DBA and Developer may want copies of their database for various purposes. I copy my database for backup purpose. However, when we hear coping database – the very first thought which comes to our mind is – Backup and Restore or Attach and Detach. Both of these processes have their own advantage and disadvantages. The matter of the fact, those methods is much efficient and recommended methods.
However, if you just want to copy your database as it is and do not want to go for advanced feature. You can just use the copy feature of the SQL Server. Here are the settings, which you can use to copy the database.
I have attempted to explain the same subject in simple words over in following video.
Here are the blog posts I have previously written on the subject of SA password. You can read it over here:
You can subscribe to my YouTube Channel for frequent updates.
Reference: Pinal Dave (http://blog.sqlauthority.com)