Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL7 Disaster Recovery
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00946889
Message ID:
00947054
Views:
14
>Try attaching the databases.
>
>You can go into Enterprise manager right click on the database tab.
>Select All Tasks-Attach Database.
>
>Point at the path of the base MDF file for you
>database.
>
>That should do it.
>
>You may need to re-establish whatever SQL logins need to be created.

Hi Rod,

Thanks, but no cigar. I tried the sp_attach_db and sp_attach_single_file_db SPs; neither worked, I believe because the databases were never detached in the first place.

It turns out they had the .MDF data files and .LDF log files on separate drives. Most of the log files on C:. However, I was able to retrieve most of the log files from the old hard drive (hadn't completely failed yet). With those in the expected locations on the new HD most of the DBs are under control now.

Thanks for the help.
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Previous
Reply
Map
View

Click here to load this message in the networking platform