Shrinking a bloated AlwaysOn log gave me: the log cannot be shrunk until All Secondaries have moved past the point where the log was added. Here is the fix.
SQL SERVER – Msg 1833 – File Cannot be Reused Until After the Next BACKUP LOG Operation
Adding a file during a demo failed with Msg 1833: file cannot be reused until after the next BACKUP LOG operation. Here is the root cause.
SQL SERVER – FIX : Error: 3456, Severity: 21 – Could not redo log record (xx:xx:xx), for transaction ID (x:xx), on page (x:xx), database ‘master’
Could not redo log record in master, error 3456, and SQL Server would not start. How we rebuilt and recovered, and the backup that makes it simple.
SQL SERVER – My Thoughts – Autogrow of File ‘SQLAuth_Log’ in Database ‘SQLAuth’ was Cancelled by User or Timed Out After 30020 Milliseconds
Seeing ‘Autogrow of file was cancelled by user or timed out after 30020 milliseconds’ in the ERRORLOG? What it means, why it happens and what to do.
SQL SERVER – FIX : Msg 35295, Level 16 – Log Backup For Database ‘DBName’ on a Secondary Replica Failed
During load testing, a log backup on a secondary replica failed with Msg 35295 because the last backup LSN was ahead of the redo LSN. Here is why.
SQL SERVER – Unable to Attach Database – File Activation Failure – The Log Cannot be Rebuilt
A client lost the log drive and tried ATTACH_REBUILD_LOG, only to get a file activation failure: the log cannot be rebuilt. Here is why and what they could do.
Identify Used Space in Log File- Interview Question of the Week #090
Question: How to identify Used Space in Log File?
Answer: Use following command to display used log file size and total used space in the log file.