.Mdf datafile object move into .ndf file. | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

.Mdf datafile object move into .ndf file.

Hi, I just like to one thing. I created a table a1 on general database into general_data.mdf file. Is it possible? I can move that a1 table to same database into gene_data.ndf file. Thanks & Regards,
Amit Kumar
Mob.: 9873812005 Amit Kumar
Mob.: 9873812005 Amit Kumar
Mob.: 9873812005
Yes, you can but you have to create .ndf file on to different file group (Secondary). You can’t move the objects to different files within the same filegroup.
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.
Forgot to mentioned…
To move table from one filegroup to another….
Create the clustered index on to different filegroup…
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.
Fyihttp://education.sqlfarms.com/ShowPost.aspx?PostID=59 Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
]]>