Solved

Error after attaching a database

Posted on 2002-06-05
6
1,081 Views
Last Modified: 2008-02-01
I am using MS SQL 2000 Server
I had attached a database (.mdf) of size of around 1GB and after attaching when i query a table using SELECT statement i am displayed around 6550 rows and then it displays an error as given below :


Server: Msg 3624, Level 20, State 1, Line 1
 
Location:      q:\SPHINX\NTDBMS\storeng\drs\include\record.inl:1447
Expression:      m_SizeRec > 0 && m_SizeRec <= MAXDATAROW
SPID:           54
Process ID:      784

Connection Broken
0
Comment
Question by:viswa20
6 Comments
 
LVL 7

Expert Comment

by:lozzamoore
ID: 7056362
Which front end tool are you using to run the Select statement from?
Cheers,
0
 

Expert Comment

by:Dr_Database
ID: 7056516
The described problem may be, that the clustered index of the table is corrupted after the failed add column attempt. A clustered index may be corrupted if all of the following conditions are met:

You tried to add a column to an existing table and in the same transaction you added a foreign key reference from the new column to a column that is a unique clustered or unique nonclustered index key on the same table.

The add column failed and the transaction was rolled back.

After the transaction failed and was rolled back, an INSERT statement to the same table may result in an error message similar to one you mentioned.

To work around this problem you can either:
Drop, and then re-create the index.
-or-
Use this statement to re-create the corrupted index:
CREATE CLUSTERED INDEX...WITH DROP_EXISTING

Hope this helps.

Regards,
Dr. Database
0
 
LVL 69

Expert Comment

by:Scott Pletcher
ID: 7057276
Is the database you attached the same version and release level (including Service Pack) as the 2000 server?  If it's not, problems may arise because of internal differences in the format of .MDFs.

If, for example, it's a SQL 7.0 database, a backup and restore -- rather than an sp_attach -- should work.  If you can't make a backup from the original .mdf source, you may need to install a SQL Server instance that's at the proper release level, attach the .mdf, do a backup, then restore that backup to your new 2000 instance.
0
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 

Expert Comment

by:modulo
ID: 7427227
Dear: Dr_Database

I've rejected your proposed answer as Experts Exchange holds an experiment to work without the answer button.

See:        http://www.experts-exchange.com/jsp/communityNews.jsp
Paragraph: Site Update for Wednesday, November 06, 2002

By this rejection the Asker will be notified by mail and hopefully he will take his responsibility to finalize the question or post an additional comment.
The Asker sees a button beside every post which says "Accept This Comment As Answer" (including rejected answers) -- so if he/she thinks yours is the best, you'll be awarded the points and the grade.

Thanks !

modulo

Community Support Moderator
Experts Exchange
0
 

Expert Comment

by:CleanupPing
ID: 9280388
viswa20:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.
0
 

Accepted Solution

by:
modulo earned 0 total points
ID: 9622400
PAQ'd and points removed

modulo

Community Support Moderator
Experts Exchange
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to shrink a transaction log file down to a reasonable size.

680 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question