Re: Error backing up Transaction Logs

From: Andrew J. Kelly (sqlmvpnoooospam_at_shadhawk.com)
Date: 05/07/04 

Date: Thu, 6 May 2004 22:10:03 -0500

You might want to give MS PSS a call.

http://support.microsoft.com/default.aspx?scid=fh;EN-US;sql SQL Support
http://www.mssqlserver.com/faq/general-pss.asp MS PSS 

--
Andrew J. Kelly  SQL MVP
"Garrett Taylor" <gtaylor@westerntitle.net> wrote in message
news:95f101c43380$92fb9c10$a301280a@phx.gbl...
> I'm running it from Enterprise Manager both as a scheduled
> job and manually.
>
> >-----Original Message-----
> >What is the actual backup command your using?
> >
> >--
> >Andrew J. Kelly  SQL MVP
> >
> >
> >"Garrett Taylor" <gtaylor@westerntitle.net> wrote in
> message
> >news:1049DD05-2DBF-499D-AE0F-C263FAB62C90@microsoft.com...
> >> This is the error I get for the database
> named, "NoteServe4005". I get
> >this error for all databases whether I attempt to backup
> manually or
> >automatically.
> >>
> >> [4] Database NoteServe4005: Transaction Log Backup...
> >>     Destination:
> >[c:\backup\NoteServe4005
> \NoteServe4005_tlog_200405041500.TRN]
> >> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3241:
> [Microsoft][ODBC
> >SQL Server Driver][SQL Server]The media family on device
> >'c:\backup\NoteServe4005
> \NoteServe4005_tlog_200405041500.TRN' is incorrectly
> >formed. SQL Server cannot process this media family.
> >> [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP
> LOG is terminating
> >abnormally.
> >>
> >> I searched support for the error pulling up only
> KB:297104 which says that
> >this can happen when transaction log files exceed 4GB.
> However, the T-Log in
> >this example is only 50MB. It also says the error is
> fixed by SP1 and I have
> >SP3a. There's also a workaround which involves setting
> the trace flag to
> >3111, but that didn't seem to make a difference either.
> >>
> >> Ideas?
> >
> >
> >.
> >

Relevant Pages