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...

SharePoint DB’s - To shrink or not to shrink the data file, this is the question: SQL Server provides you the ability to shrink the DB or shrink the files [MDF, NDF & LDF]. Shrinking the log file/LDF is quite different from shrinking the...