Evening all,
The last couple of evenings I've been recieving an error on one of the backups:
BACKUP detected corruption in the database log. Check the errorlog for more information. 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.
I've done some googeling and a few people are saying that i can change the database in question to 'Simple Recovery Model' then back to 'Full Recovery Model'
Is this good advice, is that all there is to it or is there a better solution to my error?
Many thanks
Dave