Some tips for using backup and restore in SQL Server 2016 Consider using the simple recovery model to minimize the backup/restore time and minimize administrative overhead for the transaction log. Under the simple recovery model the transaction log is not backed up. So, the data is recoverable only to the most recent backup of the lost data and the point-in-time […]