<div>
 Easiest way to do so is to detach database, move file, then re-attach <br />
&nbsp;
</div>


Easiest way to do so is to detach database, move file, then re-attach
 

<div>
Not physically moving the datafile. The primary datafile (.mdf) is in a different firlegroup than the other datafiles (ldf). &nbsp;I need to move the primary file into the same filegroup as the others and not move the datafile from drive to drive.
</div>


Not physically moving the datafile. The primary datafile (.mdf) is in a different firlegroup than the other datafiles (ldf).  I need to move the primary file into the same filegroup as the others and not move the datafile from drive to drive.

<div>
I guess that I was just being stubborn and wnated to keep the other filegroup instead.
</div>


I guess that I was just being stubborn and wnated to keep the other filegroup instead.

<div>
<div class="content wysiwyg-content">
I currently have a database where the 1st data file is in one filegroup and the other 8 files are in a second filegroup. &nbsp;I want to move the 1st file into the secondary filegroup. &nbsp;Some basic directions would be appreciated.<br />
<br />

</div>
</div>


I currently have a database where the 1st data file is in one filegroup and the other 8 files are in a second filegroup.  I want to move the 1st file into the secondary filegroup.  Some basic directions would be appreciated.



Moving existing Data file to different FileGroup

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.