asked
Rebuilding Indexes
While Rebuilding Indexes,the Database remain Online or Offline ? If it goes Offline then how the users will access the data.Will they face a downtime or will be directed to secondary ?
The database will stay online (from a SQL server sense), however depending on the edition or the reorg/rebuild process will determine on the impact to users. Even hardware would have an overall impact. Im not sure on the "....will be directed to secondary" statement. What HA/DR/Load balanced architecture do you have in place. What is your current index maint policy?
Rebuilding indexes is a process that does not take the database offline. It does cause locks to the indexes while they are being rebuilt. This will lead to blocking of access to the index during that process. If you're using Enterprise level of SQL Server, you can do an ONLINE index rebuild which radically reduces that blocking process. This will not cause any kind of failover to a second server in a cluster, always on availability group, or mirror.
@skbarik - If Grant's answer satisfied you then it would be good to mark it as accepted so others searching for the same answer can find it quickly.
16 People are following this question.
