ERROR MESAGGE:
“The statement BACKUP LOG is not allowed while the recovery model is SIMPLE. Use BACKUP DATABASE or change the recovery model using ALTER DATABASE.”
EXPLANATION:
You receive this error when you try to back up the Transaction Log of a database that has the Recovery Model SIMPLE.
SOLUTION:
A Transaction Log backup of a database that has the SIMPLE Recovery Model cannot be taken.
For more information about Recovery Models, please read the article “What is Database Recovery Model“.
