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?
Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.
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.
No one has followed this question yet.
After restoring, do i need to take a backup?
Restore of transaction log files
scripted Database restore overwrites the wrong database?
RESTORE VERIFYONLY permission
Restore a Table from a full backup?