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

    Hi,

    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
    amitkumaradmin, Apr 28, 2007
    #2

  2. Luis Martin Moderator

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


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All in Love is Fair
    Stevie Wonder


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



    Luis Martin, Apr 28, 2007
    #2

  3. Luis Martin Moderator

    Luis Martin, Apr 28, 2007
    #2

Share This Page