Thanks guys.I am talking about shrinking log file after rebuilding indexes.And sometimes we require rebuilding of some indexes daily in production environment.So, is it worth changing recovery model to...

Thanks for the reply. But what would be the better option to rebuild an index without increasing log file if it is necessary? Changing from the Full recovery model is...

Thanks...but this is not exactly what I am looking for. Listing few points of what and why will help?

You can simply install second instance or named instance on the newly active node without any nic.

We have the facility to rebuild indexes in sql server 2005. However, it is the best practice to do it offline to avoid locks on the tables incurred during index...