Question : I have a database on SQL Server Express used for 3 Asp.net applications. The Recovery Model is Full. […]
Simple and Full recovery models
Question : Not an SQL admin and new to ola-hallengren great scripts. Just wondering if people are mostly doing a […]
RECOVERY MODEL changed on a database, no record in Default Trace [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the […]
SQL Server Installer appears to be resetting MSDB Recovery Mode to Simple
Question : Everytime we upgrade a SQL Server installation (service pack or cumulative update), msdb is changed from FULL recovery […]
Transaction log is full (due to NOTHING)… but this database is in simple recovery mode
Question : I’m supporting an antedeluvian webapp (soon to be retired) that still uses “aspnetdb” for its auth system. I […]
Log Shipping – Secondary Database(s) – Which recovery model?
Question : In Log shipping configuration – the primary database must be either in Full or Bulk-Logged recovery model. However, […]
What is technical meaning of point in time recovery?
Question : Please can I have a technical meaning of point in time recovery? Does it mean that given a […]
Recovery model from Full to simple and Shrink transact log result on poor performance
Question : I’m new mantaining databases, I’m more like programmer but you know in some jobs you must be multitools […]
Transaction log backup – Only full recovery model?
Question : I am reading this book from Microsoft – it says: “A log backup cannot be performed unless the […]
Does the recovery model affect growth of the .mdf file? [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]