x

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

avatar image

pits
830 89 92 95

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

avatar image

Fatherjack ♦♦
43.7k 79 98 117

(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

avatar image

Tim
40.4k 39 84 166

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.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x2076
x79
x71

asked: Mar 04, 2011 at 06:23 AM

Seen: 930 times

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

Copyright 2016 Redgate Software. Privacy Policy