How can I restore a SQL database without using a .bak file? When I attempt to restore the database to disk or to an out-of-place location, the restore process generates a .bak file. I'm not sure how to restore the database as a regular database file with its associated transaction logs. Documentation hasn't provided any clear guidance. Can anyone help?
Thanks!