Transaction Log backup Error. Please help
As you stated the only reference I could find was related to large log
files. I don't know why the RAID would affect it for just this one file.
If your not on the latest service pack I would try upgrading first and if
that doesn't help then you might consider giving MS PSS a call. I would
suspect it's hardware related but it doesn't make sense that the logs are
the only ones affected.
--
Andrew J. Kelly SQL MVP
Targitinteractive, Inc.
Quote:
> Dear Andrew
> Thanks for your kind attention. Actually, the backup is
> being performed by the Maintenance Plan utility and as
> you know it back ups on a new file device each time.
> The problem started when I transferred my databases to a
> new server which uses a hardware RAID controller. Can it
> be the source of the problem?
> Thanks indeed.
> >-----Original Message-----
> >You might try renaming the device and trying again.
> >--
> >Andrew J. Kelly, SQL Server MVP
> >TargitInteractive
> >> Hi.
> >> I am getting the follwoing error while backing up the
> >> Transaction Log. I have searched the KB fot the error
> >> text but it says this error happens only when the Log
> >> file is very huge! My log file is just under 50 MB and
> I
> >> can Backup the log when it is Shrunk but again afet a
> few
> >> days the Error reappears. Please Help. I am very
> woried.
> >> Thanks.
> >> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3241:
> >> [Microsoft][ODBC SQL Server Driver][SQL Server]The
> media
> >> family on
> device 'C:\SQL_Backup\PakshooFinanceDatabase\PakshooFinanc
> >> eDatabase_tlog_200209151300.TRN' is incorrectly formed.
> >> SQL Server cannot process this media family.
> >> [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP
> LOG
> >> is terminating abnormally.
> >.
