SQLTeam.com | Weblogs | Forums

Moving Large Table to Different File Group


#1

Hi,
what is the fastest and safest way to move a table (or all tables within a
schema) of a File Group (primary) to another File Group (secondary -
with 8 Files).

PS. I have a lot of Table to move :sob:

Best Regards
Nicole


#2

Take a look at this link, hope this will help you out: https://www.mssqltips.com/sqlservertip/2442/move-data-between-sql-server-database-filegroups/