question

pits avatar image
pits asked

tlog fail error

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...
sql-server-2008transaction-logerror
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image ThomasRushton ♦♦ commented ·
What exactly were you trying to do, and what was the error message?
0 Likes 0 ·
Fatherjack avatar image
Fatherjack answered
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.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Tim avatar image
Tim answered
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.
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Manikreddy avatar image Manikreddy commented ·
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.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.