This question already has an answer here:
I need to clone a database in a single instance of SQL Server 2012.
I have tried the Copy Database tool in SSMS, but it fails with file access error of which I've spent all day reading around to no avail. I'm running out of time, and I need to get this database cloned, ensuring that the clone is entirely independent of the original.
The source database,
DB1 needs to retain much of its data, so Generate Scripts is also no good.
Also my version of SQL does not have the Schema Compare tool.
Can I do a full backup, but then restore to a different database name? I tried it on a dev machine, but some aspect such as it retaining the original logical name concern me (I might not need to be concerned - please advise!). Or are there any other ways to do this?