Question : Recovery mode is set to FULL, and FULL backup is taken on alternate days. No log/differential backups. Log […]
Tag: recovery-model
Setting DB to Simple Recovery then back to Full Recovery
Question : I have recently inherited all of our company’s SQL databases without much warning or experience, and was hoping […]
Why T-log is not truncated after T-log backup?
Question : I have a database myDB in full recovery model. I took a full backup and restored it on […]
How to use wal_level in Postgres to set the recovery mode to simple for a database like how Microsoft SQL Server does it?
Question : In Microsoft SQL Server, ALTER DATABASE CURRENT SET RECOVERY SIMPLE WITH NO_WAIT; will set the recovery mode for […]
SQL Server and ASP.NET – Backup Log database with Application Pool in Always Running
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, […]