December 17, 2006 at 10:42 pm
Hi All
I am hoping someone can help me out here. I have been given a set of three files:
HA_Raw_38_data.ndf
HA_Raw_38_log.ldf
HA_Raw_38_sys.mdf
we have been asked to restore the database and have a look at some aspects of the data. I am unsure as to what the original database would have been called. Can someone please help out with pointing me in the right direction as to how I would go about restoring the database represented by these files? I have some experience with SQL server but this one is a little beyond me, and the online books are a little confusing around this issue.
Any help would be greatly appreciated.
PM
December 18, 2006 at 2:01 am
PM
You should be able to attach the database. You have to specify a name - I would guess HA_Raw_38 was probably the original name. You can find the syntax for sp_attach_db in Books Online, or you can use Enterprise Manager - right click on Databases and choose All Tasks, Attach Database.
John
December 18, 2006 at 3:40 am
Hi John
Worked fine thanks, much appreciated!
PM
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply