June 5, 2003 at 1:41 pm
i am getting a 3241 error when restoring logs in log shipping. the log is not over 1 gig so the help on kb is not very helpful anybody have an idea
June 5, 2003 at 2:40 pm
What exactly the error message says? What is the severity it shows?
Shas3
June 5, 2003 at 2:56 pm
Try launching the trace flag 3111 and see. Even though MS KB says it will happen only if the transaction log back size more than 4GB, I’ve seen this on one of the server with T-Log backup around 500MB
Shas3
June 6, 2003 at 7:05 am
actually that is the first thing i tried was the dbcc traceon(3111) but i got the same error
quote:
Try launching the trace flag 3111 and see. Even though MS KB says it will happen only if the transaction log back size more than 4GB, I’ve seen this on one of the server with T-Log backup around 500MB
June 6, 2003 at 7:27 am
Please ensure restoration of transaction logs is in correct sequence.
June 6, 2003 at 8:55 am
that is a different error message
quote:
Please ensure restoration of transaction logs is in correct sequence.
June 6, 2003 at 8:59 am
here is the exact error message
Server: Msg 3241, Level 16, State 37, Line 1
The media family on device 'e:\sqlserver\mssql\backup\attain_tlog_200306030900.TRN'
is incorrectly formed. SQL Server cannot process this media family.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE LOG is terminating abnormally.
quote:
Please ensure restoration of transaction logs is in correct sequence.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply