Site icon Database Tutorials

The statement BACKUP LOG is not allowed while the recovery model is SIMPLE. Use BACKUP DATABASE or change the recovery model using ALTER DATABASE.

 

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“.

Exit mobile version