Had a crash and am trying to recreate my database. I have large files (200mb each)created using sql 7, a mdf and ldf file. When restoring on sql 2000 I get an internal consistency error trying to attach the mdf and ldf files. It fails half way through.
I desparetly need this database restored and would appreicate any help
Hi,
you could try to use the sp_attach_single_file_db and hope that this will be successfull. Seems that your database is inconsistent, do you have a valid backup ? That would be the best solution. Otherwise I hope for you that only attaching the MDF file with the above command works for you.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
No comments:
Post a Comment