all groups > sql server (alternate) > november 2004 >
You're in the

sql server (alternate)

group:

SQL corruption


SQL corruption cgaete NO[at]SPAM magallanes.cl
11/10/2004 12:22:16 PM
sql server (alternate): We've a database in MSSQL. For some reason, one transaction was
interrupted at network level. That corrupted our database. If we try
to attach it, we get the following error.

Server: message 3624, level 20, state 1, line 1

Location: page.cpp:2412
Expression: m_slots [-m_slotCnt + 1 + i].offset == 0
SPID: 51
Process ID: 944

connection broken




Any help will be kind

Re: SQL corruption Erland Sommarskog
11/10/2004 10:34:02 PM
[posted and mailed, please reply in news]

Claudia Gaete (cgaete@magallanes.cl) writes:
[quoted text, click to view]

I would strongly recommend you to open a case with Microsoft support
to resolve this. The error you see is an assertion error, that is a
programmer-added test for a condition which should be true at some
point for the following code to work. If an assertion error fires, this
is a bug in SQL Server. Even if the database is corrupted. Thus, you
should not have to pay for the case (or be refunded of what you pay
initially). I cannot guarantee that this will be the case, but whatever.
If you need to get that database back, you will need to talk to Microsoft.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
Re: SQL corruption Gang He [MSFT]
11/18/2004 5:34:08 PM
Claudia,

We would encourage you to work with Microsoft Support, too. In fact we have
some fixed several issues in SQL2000 SPs that might explain the problem you
are seeing.

--
Gang He
Software Design Engineer
Microsoft SQL Server Storage Engine

This posting is provided "AS IS" with no warranties, and confers no rights.
[quoted text, click to view]

AddThis Social Bookmark Button