Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Partition table move

Author  Topic 

SQLlife
Starting Member

5 Posts

Posted - 2009-10-15 : 14:46:10
can anyone pls explain

how to move existing data table to a newly created partionschema

--
Thanks,
SQLlife

lionofdezert
Aged Yak Warrior

885 Posts

Posted - 2009-10-16 : 06:01:32
You can partition an existing table or index without dropping and re-creating the
table or index. Instead, if you drop a clustered index and re-create it on another filegroup,
SQL Server moves the entire contents of the table into the same filegroup as
the clustered index.
so drop the existing clustered index and re-create the clustered index on your required partition scheme.
Go to Top of Page
   

- Advertisement -