Yesterday I posted a blog about database snapshot and this is somewhat an extension to it. Yesterday we checked the behavior of a database snapshot with database backups. Now let us check it’s relation with Indexes.
Let us create a database and relevant table along with indexes.
Then I manually insert data so that my indexes are fragmented which is shown below.
Then I created snapshot and as yesterday verified the file sizes.
Then did a index rebuild and verified the file sizes again.
So the sizes are increased which means index rebuild does effect the database snapshots.