title: Easiest way to make copy SQL Server DB to test DB?
body: <p>What is the easiest way to take a SQL Server database and make a test copy of it?</p>
  
  <p>I have looked through some existing topics but not sure if there is an easier way. I have database publisher. I want to be able to keep both database on the same server, potentially.</p>
  
  <p>Update: I used the Microsoft SQL Server Publishing Wizard to script to file, create a new database, add "use db", and execute the script. This seemed to work okay. The attach/detach is not recommended because it leaves links back to the original location if it is a full text search database or if the log is missing.</p>