Home Forums SQL Server 2005 Administering Can you move a table to new Filegroup/File without removing PK? RE: Can you move a table to new Filegroup/File without removing PK?

  • April 17, 2013 at 12:16 am

    #1607123

    In that case you use CREATE INDEX specifying the new file group with the DROP_EXISTING = ON clause

    See here for more detail

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉