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 |
|
zhshqzyc
Posting Yak Master
240 Posts |
 Posted - 2010-03-24 : 15:09:58
|
| Hi, after I restored a database from somewhere.I found that there are abcd.mdf,abcd_00_01.ndf,abcd_00_02.ndf,abcd_log.ldf.My question is can I merge mdf and ndf files together.Finally I only have abcd.mdf and abcd_log.ldf.Thanks. |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-03-24 : 15:12:17
|
Well ... you can merge them, however someone presumably carefully??  segregated some indexes / tables into separate tables for performance reasons - probably intended that they would be mounted on separate drives.If the multiple files aren't bothering you I would leave them alone. |
 |
|
|
|
|
|
mdf, ndf, ldf file