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...
more ▼

asked Mar 04, 2011 at 06:23 AM in Default

pits gravatar image

830 83 91 92

What exactly were you trying to do, and what was the error message?
Mar 16, 2011 at 04:08 PM ThomasRushton ♦
(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first
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.
more ▼

answered Mar 04, 2011 at 06:57 AM

Fatherjack gravatar image

Fatherjack ♦♦
42.8k 75 79 108

(comments are locked)
10|1200 characters needed characters left

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.
more ▼

answered Mar 16, 2011 at 04:18 PM

Tim gravatar image

36.4k 38 41 139

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)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Mar 04, 2011 at 06:23 AM

Seen: 789 times

Last Updated: Mar 16, 2011 at 04:12 PM