| Author |
Topic |
|
efelito
Constraint Violating Yak Guru
478 Posts |
 Posted - 2003-05-08 : 12:01:47
|
Anyone else running into this error?quote:
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3241: [Microsoft][ODBC SQL Server Driver][SQL Server]The media family on device 'X:\SQLLogs\Data\Data_tlog_200305051000.TRN' is incorrectly formed. SQL Server cannot process this media family.[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP LOG is terminating abnormally.
It is accompanied by a number of these messages in the error log.quote:
lkHeader from strip 0 At 20d0c00 ExpectedAt 20d0c00 Size 400 PrevSize 800
I have seen the KB Article (http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q297104&) that says the problem is only supposed to happen if your trans logs are over 4GB and you are running the RTM version. From the reading I've done through Google searchs this doesn't seem to be the case. People seem to be running into it with SP3 and just about every size log files imaginable. This server is running SQL2000 with SP3. It was just recently setup and had databases moved to it from a 7.0 server.Just wondering if anyone around here has come across this issue and been able to concor it.Jeff Banschbach, MCDBA |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-05-08 : 12:06:41
|
| And yet another reason why I won't install service pack 3 for SQL Server 2000. I really should keep a list of all the bugs that service pack 3 has introduced. Many have been discussed here.Just to answer your question though, I have never seen that error before.Tara |
 |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-05-08 : 12:09:32
|
| Did you try putting the 3111 trace flag on?-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
|
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2003-05-08 : 12:15:44
|
| Not yet... from what I read, sometimes it helps and sometimes it doesn't. This problem is not happening on any servers I have control over. I'm advising a friend/DBA at another company, so response time might be a bit slow. I told them to try these steps first and let me know how things go.Steps - 1) Switch to Simple Recovery Model2) Truncate Log3) Perform Full Backup4) Switch to Full Recovery Model5) Truncate Log6) Perform Full Backup7) Perform Tran Log Backup8) Let scheduled tran log backups run and see if there are still any problems.If this doesn't help I was going to have them try the trace flag. I wanted to find out more about what the flag does first.Jeff Banschbach, MCDBA |
|
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2003-05-08 : 12:19:41
|
| I'm wondering if this problem is created when a database is backed up on a SQL 7.0 server and restored to a SQL 2000 server. I've used detach and attach on all of the databases I've moved so far, and haven't personally run into this issue. But I know my friend went with backup/restore instead.Jeff Banschbach, MCDBA |
|
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2003-05-09 : 11:20:45
|
| The trans log backups ran successfully for about 4 hours (10 min interval) after following the steps above. They are looking at either creating a new db on the same server and transfering the data using DTS, enableing the trace flag, or just opening a support ticket with MS.Any thoughts on these options?Jeff Banschbach, MCDBAEdited by - efelito on 05/09/2003 11:21:13 |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-05-09 : 11:59:52
|
quote:
And yet another reason why I won't install service pack 3 for SQL Server 2000
Ahhh, Microsoft.....It's a Love/Hate type of thing...Brett8-) |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-05-09 : 12:14:58
|
quote:
... or just opening a support ticket with MS.
Probably a good idea. quote:
Ahhh, Microsoft..... It's a Love/Hate type of thing...
Brett, I'm standing right here, I can hear you.  -Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-05-09 : 12:20:20
|
quote:
Brett, I'm standing right here, I can hear you.
And?quote:
I really should keep a list of all the bugs that service pack 3 has introduced
When's S/P 4?Hey, wouldn't be doing this if I didn't like it, but hey life's a series of trade offs.Hows 2003 Server coming along....didn't realize you was a redmond boy...Brett8-)Edited by - x002548 on 05/09/2003 12:20:50 |
|
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2003-05-09 : 12:54:43
|
| This happened to be an SP3 machine, but I don't think it's SP3 specific. From what I've seen in the groups, it's happening to all releases so far.Jeff Banschbach, MCDBA |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-05-09 : 13:36:16
|
quote:
Brett, I'm standing right here, I can hear you. And?I really should keep a list of all the bugs that service pack 3 has introducedWhen's S/P 4?Hey, wouldn't be doing this if I didn't like it, but hey life's a series of trade offs.Hows 2003 Server coming along....didn't realize you was a redmond boy...
I was just kidding. I get snide MS remarks on a daily basis, I have learned to address the ones I can, and ignore the rest.I don't actually live in Redmond, I live in Phoenix, I'm an MCS consultant. Haven't heard anything about SP4, I am working full time on a .Net project, so I don't have time to keep up with the latest SQL news.I used to have 2003 Beta 2 loaded on my laptop, but I took it off a while back, it was great, but I haven't had the opportunity to really use any of the new features etc.. yet.-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-05-09 : 13:54:04
|
| Chad,I've had no exposure to .NetWhat's the big deal with it? Seems to becoming the up and coming new thing....What is it though...any basic reading for entry level stuff.Do you know if Yukon will be tightly integrated with it?Brett8-) |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-05-09 : 14:12:41
|
| I think that subject is to large to tackle here:If you are interested in basics, start here:http://www.microsoft.com/net/basics/There are tons of books available as well.Yukon will be tightly integrated with it. SQL objects will be able to be written in any CLR language. (CLR is Common language Runtime, the framework that .Net (Managed) code runs in). There are a lot of other things, but I'm not sure what is public Info and what is not, so I don't want to say too much. There will be a lot of new public info unveiled at the PDC.-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2003-05-09 : 14:12:45
|
| I've had a ton of exposure to ASP.net + VB.net + SQL2000 and I must say I'm really happy with it. Generally, it's TONS faster to write and test applications in .net, but they tend to use more memory from what I've seen thus far. The use of the memory makes the ASP.net stuff really fast though (caching!).I'm about to fire up my Win2003 Web Ed. Server and see how that works out.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2003-05-12 : 10:13:58
|
Interesting stuff guys, but am I allowed to call Hijack here? Jeff Banschbach, MCDBA |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-05-12 : 11:26:47
|
| Yup...Did your friend ever resolve hi problem?Brett8-) |
|
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2003-05-12 : 12:35:54
|
| Not yet. I have a hunch that its a problem created when databases are upgraded from 7.0 to 2000 via backup/restore. He is going to try creating a 2000 DB from scratch and then transfering all objects and data from the upgraded db to the new db. In the interium they are doing more frequent full and diff backups to maintain recoverability. The database is only about 4 GB, so its fesable for them to take quick full backups during the day. Let you know if the transfer makes a difference.Jeff Banschbach, MCDBA |
|
|
|
goofy
Starting Member
2 Posts |
Posted - 2003-05-31 : 11:03:19
|
| Thank you all so far for the suggestions. This is efelito's friend with the problem, and my first post on this forum.The object transfer to a new database did not help. We are moving to the trace flag suggestion and will monitor things from there. |
|
|
|
goofy
Starting Member
2 Posts |
Posted - 2003-09-10 : 14:18:31
|
| Thank you all for the help. Efelito found someone with this issue, and turns out it's hardware related. We started pointing our transaction log backups to a share on another server (instead of the local server's hard drives), and the problem disappeared! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-10 : 14:20:24
|
| I hope that the hardware problems get resolved so that you can backup the transaction logs to the local drive, as this is the recommended approach.Tara |
|
|
|
|
Tran Log Backup Problems