Hi Peeps,

My WIN2000 crashed and now I've got my databases and need to attach them. The smaller DBs have attached without a problem but the main DB which is about 17.2GB comes up with an error after a little while:

MS SQL-DMO(ODBC SQLState:HY000)
Error 3624:
Location: scanrid.cpp:321
Expression: m_len: !=0
SPID: 53
Process ID: 880


Please help!!

Thanks

Hi,

I believe that u don;'t have a backup of ur main database to restore from and you have kept the .mdf and .ldf files and now trying to attach those.

Not sure about the file placement (.mdf, .ndf,.ldf etc.). Will be better if you provide some more data about your new configuration and File placement.

Gud luck.

B. Anant

Hi again,

You can try to attach the database in Single user mode (take ur SQL server to Single user mode first). This may be a ovrload issue.

B. Anant