Browse by Tags

Related Posts
  • Blog Post: 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...
  • Blog Post: 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...