I am using sql 2008,
The tlog failed for database some hrs before and now its running well...,there is no reason capture in applicatin logs,the application logs says only tlog failed...the same database is in full recovery mode...also full back up was in place...the drive has enough space...
what can be the reson of transaction log fail?
is there any way to check if recovery mode is changed,...if yes when?by which user?...ect
In the job itself that was backing up the log should have some information as to why the tlog backup failed in the job history. Feel free to update your question with the contents of the backup step that failed. It may be the error is rather generic. There could have been an error writing to disk, SQL Server Agent could have been restarted, etc.
As to your question about the recovery model being changed, that event should be logged in your SQL Server Log.