I am needing to restore a SQL server 7 database. I had a backup, but the media it was on has failed. I have copies of the folder the original database was in (.mdf files and such), but I was wondering if there is a way to re-integrate these files in order to pick up where we left off. Thank you.
if you have copies of .mdf and ldf file you can attach that file. read about sp_attach_db in BOL.
Madhu
|||Thank you very much; after some tinkering (and thanks to the information you gave me), I was able to restore the database. This has saved me countless hours of downtime; thank you!
No comments:
Post a Comment