Posts

Showing posts with the label database

Backup Detected Log Corruption In Database Context Is First Sector

Image
Backup Detected Log Corruption In Database Context Is First Sector . If ms sql server backup detected corruption in the database log and you want to resolve the condition, follow the suggestion laid out below: Switching recovery model from full to simple and then switch it back to full. from venturebeat.com For that, users can perform these steps sequentially: 2 'c:\program files\microsoft sql server\mssql10_50.mssqlserver\mssql\data\tfs_vlrcconfiguration_1.ldf' vlf. Switch to the simple recovery model (breaking the log backup chain and removing the requirement that the damaged portion of log must be backed up) switch to the full recovery model.