I have a SQL 2014 instance containing a database with the following properties:
SQL Host: sqlprod
DB User: ecmuser
I have a production web app that connects to the db with the properties above.
I'm trying to stand up a test instance of the web app. Can I copy (backup/restore) the ecm db on the same SQL host? ....Essentially creating a new db with the name ecmtest, and restoring a backup of ecm to ecmtest.
Would this work? Or do I need a new SQL instance?
Thanks in advance.