Steps to move lob_data table to another file group in same database without downtime?

Question

How to move lob_data columns like image, text, varbinary tables to another file group in same database without downtime?

Answer 1

Hi，@ShanlyV-5349

Welcome to Microsoft T-SQL Q&A Forum!

Before 2020, we usually say that we can only rename the new table by creating a new table of the same type and moving the data. Last year I browsed a partition implementation method, please browse this post, it will help you.

Best regards,
Bert Zhou

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

without downtime?

You can't.
To move lob_data to a different file group you have to alter the table design and that locks the table complete until data move completed.

The only way is a much more complexe process, e.g. make copies on the tables in new design, copy over data, drop old tables, rename new tables etc.

Answer 3

You can't.
To move lob_data to a different file group you have to alter the table design and that locks the table complete until data move completed.

The only way is a much more complexe process, e.g. make copies on the tables in new design, copy over data, drop old tables, rename new tables etc.