Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
poolguymsj
Starting Member
2 Posts |
 Posted - 2005-07-29 : 12:09:25
|
| Hi, I am a summer intern in an IT Dept in Cincinnati. I've got an MDF and an NDF which I suspect to contain the information I need to extract and organize. We recieve a Bill on CD that needs to be broken down by dept. It appears as though the CD's program retrieves its information from these two files. an MDF and an NDF. Maybe I'm WAY off. I installed Desktop SQL Server from Microsoft.1) MDF=Master data file, NDF=secondary data file... which is the right one?2) How can I qry the nesecary file to retrieve the data. I'm extreemly new to using SQL. I have access to some more experienced programmers. but I want to make sure I'm on the right track before I present my ignorance to them.any constructive suggestions and opinions are appreciated.I hope I've come to the right forum to ask for help."The major difference between a thing that might go wrong and a thing that cannot possibly go wrong is that when a thing that cannot possibly go wrong goes wrong it usually turns out to be impossible to get at orrepair." Douglas Adams on Programming. |
|
|
nathans
Aged Yak Warrior
938 Posts |
Posted - 2005-07-29 : 12:15:29
|
| Youll need to attach the .mdf/.ndf files... SQL will automatically create an .ldf file for you when you attach. You will then be able to query the database via Query Analyzer, etc as normal.Here is an okay walk-through:http://www.databasedesign-resource.com/moving-the-database.htmlNathan Skerl |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-07-29 : 12:33:53
|
| Just so you know what to expect, the ATTACH process is a bit fragile (you would be better off with a Backup of the DB, rather than a copy of its actual live files - they might have been copied without the DB being shut down, or a host of other complications might ensue)Kristen |
|
|
|
|
|
|
Extract from NDF?