question

kardile avatar image
kardile asked

Table & Index Fragmentation

What happen to fragmentation if the fragmentated Tables & Indexes are backed up & restored on different server?

Does it create the tables & indexes with similar fragmentation?

restorefragmentation
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Kev Riley avatar image
Kev Riley answered

Database backups and restores operate at the page level, so any fragmentation of data and indexes on the pages present when the backup is taken, will be restored.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.