I have one sql server instance with two databases :
both point to separate mdf and ldf files and are backed up each night. I want to take a copy of LIVE and put it in TEST. I would even like to do this as a regular job, what is the best way ?
I can do a restore from a live back-up but was concerned I would overwrite the existing live database as they are on same server instance ?