Target Recovery Time - new database option in SQL Server 2012

  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 2012. This option helps us to control checkpoints…


Recovery models

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 SIMPLE, every DML and DDL statement is…