<div>
Search BOL for DBCC SHRINKFILE
</div>


<div>
Thanks Kuki for your reply, &nbsp;after a closer examination of the database there are 3 filegroups. One is the Primary and the other 2 match the names of the .ndf files. I rewrote my restore script using With Recovery, Replace and specified the .ndf files using MOVE TO and that worked to get all the tables so i can view them.<br />
<br />
Thanks again for your solution, that was the method I was trying to remember. 
</div>


Thanks Kuki for your reply,  after a closer examination of the database there are 3 filegroups. One is the Primary and the other 2 match the names of the .ndf files. I rewrote my restore script using With Recovery, Replace and specified the .ndf files using MOVE TO and that worked to get all the tables so i can view them.

Thanks again for your solution, that was the method I was trying to remember.

<div>
<div class="content wysiwyg-content">
Hello Experts, <br />
Is there a way to migrate an .ndf file back into the .mdf. They are both in the same filegroup of course, and I rememeber reading somewhere this could be done. Any assistance is greatly appreciated even if its to tell me that it can't be done.<br />
Thanks, <br />
<br />
JackW
</div>
</div>


Hello Experts, 
Is there a way to migrate an .ndf file back into the .mdf. They are both in the same filegroup of course, and I rememeber reading somewhere this could be done. Any assistance is greatly appreciated even if its to tell me that it can't be done.
Thanks, 

JackW

Migrate .ndf into .mdf

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.