We have a database file that is called main-db.bak.
This is the database file that we have cloned as it contains all the main things we need in the process of constructing new websites for our clients. Is it possible to do the following:
Have a copy of the database on the same SQL Server Instance
Create a new empty database
Restore the database from main-db.bak file and not overrite anything else that may be using the same data MDF and LDF files?
Or would it be easier to reproduce this database from a live running database copy so that it is not needed to restore if from backup?
Is it mandatory to rename the LDF and MDF files when the database is restored, can I script to automate the majority of the work?