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.

image

Then I manually insert data so that my indexes are fragmented which is shown below.

image

Then I created snapshot and as yesterday verified the file sizes.

image

Then did a index rebuild and verified the file sizes again.

image

So the sizes are increased which means index rebuild does effect the database snapshots.

No comments:

Post a Comment