I have a production database with Full recovery mode where the MDF and LDF files are approx 80GB each.
We have a test server that we restore this database to on a regular basis for dev / test purposes, etc.
At the moment the restore has happened, we set the recovery model to Simple and shrink the log file as the server is low on disk space.
Is there a way of restoring the database straight to Simple mode so that the large LDF file is never created?