MS SQL Database Bad MOJO

We have a client that has a MS Sql 7 database who's drive array failed. Unfortuately, the array failed while the database was open. It had not been detached and reattached so as to be backed up. The previous tech led the company to believe that he had written a custom script to down the database, detach it, back it up, reattach it, and move the backed up copy to another server. Well it never worked.

Additionally, the previous tech had the OS and the database on the same array. Array failed, all is lost.

We have been able to recover the databases to another drive and move them to a new server, but they were attached to the old server.

Is there anyway, utility , or other to re-attach this databse to the new server?

I'm willing to kill a chicken if necessary.

Thanks in advance...charles

if you are talking about attaching a .mdf file to the new server....why don't you just run the sp_db_attach to attach it to the new server.

Will this work if the database was not detached at the time of failure?

yes, just copy the .mdf file to the new server, then open query analyzer and follow the procedure for sp_db_attach.