Sunday January 21st 2018

Categories

Insider

Archives

The transaction log for the database is full

Data cleansingo fix this problem, change Recovery Model to Simple then Shrink Files Log

1. Database Propertise > Options > Recovery Model > Simple

2. Database > Shrink > Files > Log

Done.

Then check your db log file size at Database Propertise > Files > Database Files > Path

To check full sql server log: open Log File Viewer at SSMS > Database > Management > SQL Server Logs > Current