SQL corruption

[Claudia Gaete]

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

regards!

[Erland Sommarskog]

[posted and mailed, please reply in news]

Claudia Gaete (cg****@magallanes.cl) writes:

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

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, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

[Gang He [MSFT]]

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.
"Erland Sommarskog" <es****@sommarskog.se> wrote in message
news:Xn**********************@127.0.0.1...

[posted and mailed, please reply in news]

Claudia Gaete (cg****@magallanes.cl) writes:

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

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, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp