Does fragmentation changes after backup/restore operation?

Hello,

If i backup a database and then restore it, would physical structure remain the same? specially fragmentation.

I'm concerned about output of DBCC SHOWCONTIG.

Senario: I want to check if client database needs defragmentation, so he's sending db backup file. But is it possible that when i restore it fragmentation info has got lost?

Thank you.

Table/index fragmentation should be unaffected by BACKUP/RESTORE.

|||

And i hope it's same for tranferring .mdf file to be attached later?

?

|||Yes, it is the same for detach/attach.