SQL Server Performance

.Mdf datafile object move into .ndf file.

Discussion in 'SQL Server 2005 Reporting Services' started by amitkumaradmin, Apr 28, 2007.

  1. amitkumaradmin New Member


    I just like to one thing. I create one 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
  2. Luis Martin Moderator

    If the table has cluster index you only have to change the cluster to the new filegroup.

    Luis Martin

    All in Love is Fair
    Stevie Wonder

    All postings are provided “AS IS” with no warranties for accuracy.

  3. Luis Martin Moderator

Share This Page