Recovering database - need help with 2 errors

[demoman]

Howdy

We lost a server to hardware failure. SQL Server required a new installation. I attached our database 'otg4' using sp_attach_db. This was successful, or partially so. Now when I try to view the data I get mixed results. In some cases it works fine.

Some tables produce the following error:

[microsoft][ODBC SQL Server Driver][SQL Server]Attempt to fetch logical page (1:3252) in org4 belongs to object 'ae_dt2, but to object 'ae_apps'.

Other tables produce the following error:

[microsoft][ODBC SQL Server Driver][SQL Server]Location: statutil.c:1845
Expression: resultSize == blobSize
SPID: 8
ProcessID: 1760

I would be ever so appreciative of any guidance provided.

Steve
stevem@nuprecon.com

 

[JJayUK]

Are you sure you included *all* the files when attaching to the database? Some databases may have more than one data file (.mdf) or log file (.ldf).

Make sure you definitly rememebered to attached the Log file as well.

Regards,
JJayUK

 

[demoman]

Both files are attached correctly

 

[tlbroadbent]

Have you run DBCC CheckDB or DBCC checktable since attaching the databae. DBCC may find and correct any problems with the database. Terry L. Broadbent
Programming and Computing Resources

http://tlbroadbent.home.attbi.com/prog.htm