I have tried to take a full following with a log back up for a new database on our server with recovery modell as full. But we had the following error while transaction log backup as the db is in simple recovery
name create_date recovery_model_desc
XXXXX 15/10/2015 11:00 FULL
Executing the query "BACKUP LOG [XXXXX] TO DISK = N'L:\\MSSQL\\Backu..." failed with the following error: "The statement BACKUP LOG is not allowed while the recovery model is SIMPLE. Use BACKUP DATABASE or change the recovery model using ALTER DATABASE.
BACKUP LOG is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Could please let me know why tarnasction backup failes even though it is in Full recovery after a full backup?
Thanks in advance.