I am trying to find out the impact of a database reindex on an SQL Server backup.
The scenario is as follows:
I have a database called ABC that I perform a backup of to a flat file using the command in a SQL Agent job - BACKUP DATABASE ABC TO DISK = 'C:\Backups\ABC.DAT' WITH INIT
Now I perform some defragging of indexes in the database using REBUILDS for those with a fragmentation over 30% and a REBUILD for over 10%.
The database remains in FULL mode while this is running.
Once complete I perform another backup of the database to a flat file using the same method as before - BACKUP DATABASE ABC TO DISK = 'C:\Backups\ABC.DAT' WITH INIT in a SQL Agent job.
What I would like to know is if the data held within the backup file has changed its order?