Recently I’ve created a new database on my SQL Server 2012 instance. I reviewed the new database options before creating. One of the options that I’d like to share today is “Target Recovery Time” in seconds or TARGET_RECOVERY_TIME. Target Recovery Time is new in SQL Server...

Recovery model is our way to instruct SQL Server how to maintain the log file. We have 3 recovery models in SQL Server – SIMPLE, BULK_LOGGED and FULL. We’ll review them and describe the differences between them. SIMPLE recovery model When the database recovery model is set to...