Error while attaching the Database

[tumtoo10]

Server: Msg 3624, Level 20, State 1, Line 1

Location : recovery.c:2657
Expression : seenCkptEnd
SPID : 9
Process ID : 900

Connection Broken

When attaching the database to the sql server 7.0 it gives this error and hence unable to attach.

 

[JayKusch]

If you are trying to attach a SQL Server 2000 database in to a SQL Server 7 instance, you cannot and may recieve this error.

If you are trying to attach a SQL Server 7 DB into a SQL Server 7 instance OR are trying to attach a SQL Server 7/2000 DB into a SQL Server 2000 instance and are receiving this error, you may have a corrupt DB file (MDF).

Thanks

J. Kusch

 

[tumtoo10]

First of all Thank you very much for the reply. I would also like to know if the DB is corrupted, can we retrieve the data from that DB & how? I am attaching SQL Server 7 DB into a SQL Server 7.

Thanks
Syed

 

[JayKusch]

You would first have to get it attached. With luck it will attach w/out an issue but it looks like we may be past the mark now. The next mark we will try to hit is getting the DB to attach in Suspect mode. If we can get it there we may be able to reset its status and be fine. If not we may need to put it in Recovery mode and try to export as much of the DB as we can.

First of all, if you have the room somewhere, make a copy of the MDF and LDF for safe keeping in case we need to start from scratch w/ the Microsoft techs if need be.

SO .. take a look at BOL (Books OnLine) for the syntax of attaching a DB. From what you have said already, this may not work.

Next try the sp_attach_single_file_DB command after you rename your current *.LDF to something like *.LDFhold.

Let us know how this goes and good luck!

Thanks

J. Kusch