recovery-model Archives

Transaction log file size growing, what will be the consequences of setting recovery mode to simple

By adminPosted on July 22, 2023

Question : Recovery mode is set to FULL, and FULL backup is taken on alternate days. No log/differential backups. Log […]

By adminPosted on June 10, 2023

Question : I have recently inherited all of our company’s SQL databases without much warning or experience, and was hoping […]

By adminPosted on May 31, 2023

Question : I have a database myDB in full recovery model. I took a full backup and restored it on […]

By adminPosted on March 28, 2023

Question : In Microsoft SQL Server, ALTER DATABASE CURRENT SET RECOVERY SIMPLE WITH NO_WAIT; will set the recovery mode for […]

By adminPosted on March 11, 2023

Question : I have a database on SQL Server Express used for 3 Asp.net applications. The Recovery Model is Full. […]

By adminPosted on December 31, 2022

Question : Not an SQL admin and new to ola-hallengren great scripts. Just wondering if people are mostly doing a […]

By adminPosted on November 16, 2022

Question : Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the […]

By adminPosted on August 22, 2022

Question : Everytime we upgrade a SQL Server installation (service pack or cumulative update), msdb is changed from FULL recovery […]

By adminPosted on August 21, 2022

Question : I’m supporting an antedeluvian webapp (soon to be retired) that still uses “aspnetdb” for its auth system. I […]

By adminPosted on July 19, 2022

Question : In Log shipping configuration – the primary database must be either in Full or Bulk-Logged recovery model. However, […]