You can use backup files : Backup (full) the old database, then retore it giving a new database name with the replace option
You can use data files : Put your old database offline, and copy the data and log files (.mdf and .ldf) then put old database online. Now you can rename duplicate files, then attach them.
Both solutions need to understand basic sql server operations, choose the one you feel the more simple for you!
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.