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 please advise...
(comments are locked)
|
Do you mean the backup of the transaction log failed? What was the error message? You need a Full backup as well as a TLog backup in order to be able to restore a database successfully.
(comments are locked)
|
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. I agree with TRAD if the backup failed with change of recovery model it will write in sql log and t-log backup will failed with error there is no fullbackup.
Mar 16, 2011 at 10:31 PM
Manikreddy
(comments are locked)
|
What exactly were you trying to do, and what was the error message?