Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
spot at the beach
Starting Member
3 Posts |
 Posted - 2004-09-21 : 19:24:34
|
| I am trying desperately to attach a .mdf file to a SQL Server Database (2000, SP3). No matter what I do, the process is failing. Unfortunately, there is no backup and the .mdf file is the only access I have to the data and stored procedures. Here is the error:Error 3264:Location: p:\sql\ntdbms\storeng\drs\include\record.inl:1447Expression: m_SizeRec > 0 && m_SizeRec <= MAXDATAROWSPID: 51Process ID: 2860Is there any way to fix this error or am I basically screwed? ANY assistance on this would be appreciated.~John :) |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-09-21 : 19:52:43
|
| Well, this might be one of those times when a $200 phone call to Microsoft is in order. If they can't help you, noone can.http://support.microsoft.com/default.aspx?scid=fh;en-us;Prodoffer41a&sd=GNWell, it's up to $245, but it's still worth it IMHO. The Question you have to ask yourself is "Is what I'm trying to restore worth $245?".If so, make the call.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
 |
|
|
spot at the beach
Starting Member
3 Posts |
Posted - 2004-09-21 : 20:10:36
|
| Luckily some more Google searching finally paid off. The resolution is to copy the MDF/LDF files elsewhere and then re-create the database. After that, replace the files and everything should be about fixed. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-09-22 : 13:12:47
|
| Sounds risky to me. However, if it works thats fine, eh?make sure SQL is not running when you replace the MDF/LDF files - and keep a copy of the original!There is an issue if you are trying to ATTACH an MDF that was previously NOT properly DETACH'ed if you attempt to attach it from a DIFFERENT Drive/Path to the original. (I've forgotten the fix for that, but it did come up on SQL Team in the last few months)Kristen |
|
|
|
nr
SQLTeam MVY
12543 Posts |
|
|
spot at the beach
Starting Member
3 Posts |
Posted - 2004-09-22 : 21:24:27
|
| Lesson learned. Thanks so much for your help. |
|
|
|
Kristen
Test
22859 Posts |
|
|
|
|
|
|
|
Can't Attach DB