Monday, July 30, 2012

Database Snapshots in Index Rebuilding


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.

No comments:

Post a Comment